Home > Microsoft Access Help
Microsoft Access Help
Microsoft Access forum discussing questions and answers for the Access database. MS Access is used to handle small to medium database needs.
Table for Tee Time Bookings. PLEASE HELP!! URGENT!!
I have an assignment due on tuesday, and im really really really stuck with this last table which i need to create. The idea ok, is to have a database to store the bookings for tee times from a ASP page and a VB program. The ASP pag...
I have an assignment due on tuesday, and im really really really stuck with this last table which i need to create. The idea ok, is to have a database to store the bookings for tee times from a ASP page and a VB program. The ASP pag...
answer(1) view(830) status(
)
)
** Switchboard help **
k i made my switchboard and everyfing...jus wana make it look good and add some features into it...plz answer the following... 1) how do i show the time on the switch board? 2) how do i show the date on the swithboard? 3) any good site...
k i made my switchboard and everyfing...jus wana make it look good and add some features into it...plz answer the following... 1) how do i show the time on the switch board? 2) how do i show the date on the swithboard? 3) any good site...
answer(1) view(558) status()
)
prevention of edit forms/tables
hi how do i prevent user from entering into the 'design view', 'datasheet view' of my form??? how can i prevent them for entering to the database window (where you can choose to create table in design view or wizard.)?? pls advice no...
hi how do i prevent user from entering into the 'design view', 'datasheet view' of my form??? how can i prevent them for entering to the database window (where you can choose to create table in design view or wizard.)?? pls advice no...
answer(10) view(765) status()
)
print form
hi, i have a form which i have created; the width is too wide so whenever i want to print the form in ONE page, i have to go to change the settings before i print. how can i fixed the printing settings for this form???? pls advice ...
hi, i have a form which i have created; the width is too wide so whenever i want to print the form in ONE page, i have to go to change the settings before i print. how can i fixed the printing settings for this form???? pls advice ...
answer(2) view(36) status()
)
repair and compact database
hi how can i auto repair and compact my database each time the database is closed??? pls advice nono
hi how can i auto repair and compact my database each time the database is closed??? pls advice nono
answer(4) view(642) status()
)
exporting asp from access
I made a simple database with access, and then used "export" to create a asp page. But the page just shows the field names but no data: just one empty line. Database is added as a system data source. And there doesn't seem...
I made a simple database with access, and then used "export" to create a asp page. But the page just shows the field names but no data: just one empty line. Database is added as a system data source. And there doesn't seem...
answer(0) view(615) status()
)
Passing Parameters to Stored Procedure in MS Access
Hi I am trying to pass date parameters from MS Access form to stored procedure on SQL server . When I execute the code I am getting an error on "qd.execute " The error message is Number: 3065 Source : DAO.QueryDef Te...
Hi I am trying to pass date parameters from MS Access form to stored procedure on SQL server . When I execute the code I am getting an error on "qd.execute " The error message is Number: 3065 Source : DAO.QueryDef Te...
answer(0) view(560) status()
)
Help with duplicates query
I have a table with various fields, two of which are "date" and "serial number". I'm trying to construct a query which will return all records unless there are multiple matches in the "serial number" field , in...
I have a table with various fields, two of which are "date" and "serial number". I'm trying to construct a query which will return all records unless there are multiple matches in the "serial number" field , in...
answer(2) view(292) status()
)
change color in listbox
In access, as I change color of text of a column of a listbox
In access, as I change color of text of a column of a listbox
answer(1) view(12) status()
)
query based on time
i am writing a query for fetching record of service centers which will be open during the time entered by the user. the opening hour and closing hour of service center are in 24 hour clock. the exact problem is that there are certain cente...
i am writing a query for fetching record of service centers which will be open during the time entered by the user. the opening hour and closing hour of service center are in 24 hour clock. the exact problem is that there are certain cente...
answer(2) view(274) status()
)
ODBC error
If someone can help me figure this error out Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for proce...
If someone can help me figure this error out Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for proce...
answer(0) view(384) status()
)
linking outlook to an access table
Hi everyone I have linked an outlook contacts table into an access table. But i need a way to give it a primary key so i can link the new access table with other tables in the database. My main problem has been that access doesn't allo...
Hi everyone I have linked an outlook contacts table into an access table. But i need a way to give it a primary key so i can link the new access table with other tables in the database. My main problem has been that access doesn't allo...
answer(3) view(20) status()
)
Transfering multible xls files to access...
I have more than 500 small excel files that have different names but same formating.I want to import all that information into access into one table with again the same headlines... Is there a fast way of doing this? Also all these files ...
I have more than 500 small excel files that have different names but same formating.I want to import all that information into access into one table with again the same headlines... Is there a fast way of doing this? Also all these files ...
answer(1) view(23) status()
)
Command Button
I'm learning as I go with Access, but I have come across a problem that I can't seem to figure out. I have a button that I have set to open a form, however I need it to open the form with a new record as the default and I can't figure out t...
I'm learning as I go with Access, but I have come across a problem that I can't seem to figure out. I have a button that I have set to open a form, however I need it to open the form with a new record as the default and I can't figure out t...
answer(7) view(458) status()
)
edit data in a form
i have a form with data that cant be edited (allow editions.....NO, in the form properties). i'd like find a way to give the choice to edit a particular record .... thanks
i have a form with data that cant be edited (allow editions.....NO, in the form properties). i'd like find a way to give the choice to edit a particular record .... thanks
answer(3) view(205) status()
)
Query Linking
I am trying to perform a query on Access. I have a global set of names in one table that I am trying to link with monthly payments in another table. The first and last name are key fields in each table. The problem is when I query, if ...
I am trying to perform a query on Access. I have a global set of names in one table that I am trying to link with monthly payments in another table. The first and last name are key fields in each table. The problem is when I query, if ...
answer(1) view(445) status()
)
Adding multiple data to large DB on server
Hi! I want to add quite a large amount of data (~5MB) from an Access DB on my computer to an existing Access DB (~50MB) on a web server. What would be the most appropriate way of doing this without having to download/upload the entire or...
Hi! I want to add quite a large amount of data (~5MB) from an Access DB on my computer to an existing Access DB (~50MB) on a web server. What would be the most appropriate way of doing this without having to download/upload the entire or...
answer(2) view(577) status()
)
How to modify Table entry via form
I m very very new to MS Access and had been scratching head to figure out how this works. I have created a applicaiton that ask user to logon to it, and then modify their own personal info. When user logon, i will read in their logonI...
I m very very new to MS Access and had been scratching head to figure out how this works. I have created a applicaiton that ask user to logon to it, and then modify their own personal info. When user logon, i will read in their logonI...
answer(2) view(130) status()
)
Changing cursor location in a text box
When I click on an empty text box the cursor automatically jumps to the far left of the box no matter what part of the box I click on(which is what I want). However, when there is an input mask in the box, the cursor goes right to where I...
When I click on an empty text box the cursor automatically jumps to the far left of the box no matter what part of the box I click on(which is what I want). However, when there is an input mask in the box, the cursor goes right to where I...
answer(2) view(525) status()
)
create a loop and assign a value for each field
I'm coding a form for MS ACCESS. When I lock/unlock fields, I do so declaring each field. How can I create a SUB that will loop through all the fields and assign the true/false value as needed. So that if I have 20 fields, I don't have t...
I'm coding a form for MS ACCESS. When I lock/unlock fields, I do so declaring each field. How can I create a SUB that will loop through all the fields and assign the true/false value as needed. So that if I have 20 fields, I don't have t...
answer(3) view(934) status()
)
last two rows PLSSS HELP
Hey everyone I have an access db and a table called crustPrices I want to be able to retrieve the last two records(rows) of the table how is that possible using an SQL statement pls i would really appreciate help
Hey everyone I have an access db and a table called crustPrices I want to be able to retrieve the last two records(rows) of the table how is that possible using an SQL statement pls i would really appreciate help
answer(1) view(32) status()
)
adding new record
What am i doing wrong. this code use to work in 97' but not in xp '------------------------------------------------ Private Sub AddRec_Click() Dim rs As Recordset Dim MyDB, MyTable Set MyDB = CurrentDb() Set rs = M...
What am i doing wrong. this code use to work in 97' but not in xp '------------------------------------------------ Private Sub AddRec_Click() Dim rs As Recordset Dim MyDB, MyTable Set MyDB = CurrentDb() Set rs = M...
answer(3) view(236) status()
)
asp and database configuration problem
hi all. i posted this in the asp forum but maybe you database experts will have more info for me (note: i am NOT a database guru) am using asp and cdonts to send an html form to both an email address and a database (Access). have used th...
hi all. i posted this in the asp forum but maybe you database experts will have more info for me (note: i am NOT a database guru) am using asp and cdonts to send an html form to both an email address and a database (Access). have used th...
answer(1) view(361) status()
)
Selecting Table From Drop - Down Box
Hi, I've got a form with a button that runs a query. This gets all results on a keyword in a table. I was wondering if there was any way that I can use a drop-down box on this form to select the table I want to run the query on? Tha...
Hi, I've got a form with a button that runs a query. This gets all results on a keyword in a table. I was wondering if there was any way that I can use a drop-down box on this form to select the table I want to run the query on? Tha...
answer(1) view(937) status()
)
Validation...PLS Help
Hi, quite new to MS Access, just wondering if anyone could help with the following validation rule. Right, for a school project i am creating a booking system. Because only over 18 are only allowed to book, within the customer details...
Hi, quite new to MS Access, just wondering if anyone could help with the following validation rule. Right, for a school project i am creating a booking system. Because only over 18 are only allowed to book, within the customer details...
answer(3) view(266) status()
)
help with if exist plz
I am having trouble getting this code to work. I want to check the email submited to my access db via post then if the email already exist then tell the user they need to choose another email address because this on already is in there. he...
I am having trouble getting this code to work. I want to check the email submited to my access db via post then if the email already exist then tell the user they need to choose another email address because this on already is in there. he...
answer(2) view(424) status()
)
Access Reports from ASP pages
Is there a way to run an Access report macro from an ASP page? Data would actually be coming from a SQL 2000. Esentially what I have to do is pull a row of data from the DB and create a printable document from it. Maybe there is a better wa...
Is there a way to run an Access report macro from an ASP page? Data would actually be coming from a SQL 2000. Esentially what I have to do is pull a row of data from the DB and create a printable document from it. Maybe there is a better wa...
answer(1) view(868) status()
)
TransferDatabase????
Hello, I have an application I wrote in Access to transfer .mdb files to .dbf files. However, I need to do it through ASP. Is this possible using the TransferDatabase action of doCmd? Is there a better way to do this with ASP? Than...
Hello, I have an application I wrote in Access to transfer .mdb files to .dbf files. However, I need to do it through ASP. Is this possible using the TransferDatabase action of doCmd? Is there a better way to do this with ASP? Than...
answer(1) view(197) status()
)
Project Help
Does anyone have an Microsoft Access system they could share with me....or know any links to sites that have free downloadables shared projects........ I have to create a simple booking system but new to Access so kinda struggling tha...
Does anyone have an Microsoft Access system they could share with me....or know any links to sites that have free downloadables shared projects........ I have to create a simple booking system but new to Access so kinda struggling tha...
answer(1) view(466) status()
)
Help with Calculations in Report
I have a db that tracks citrus orders. In the customer orders form the clerk enters a citrus type, box size (full or half), and a quantity. The unit price is looked up from the products table, which contains separate prices for full and hal...
I have a db that tracks citrus orders. In the customer orders form the clerk enters a citrus type, box size (full or half), and a quantity. The unit price is looked up from the products table, which contains separate prices for full and hal...
answer(1) view(454) status()
)
Programming
Home -
About Infoqu -
Contact -
Privacy Statement -
Link to Infoqu -
Bookmark Infoqu
Copyright 2007-2008 by Infoqu. All rights reserved
Copyright 2007-2008 by Infoqu. All rights reserved