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.
ADODB.Recordset error '800a0bb9'
Hello, I am new to asp so if anyone would be kind enough to help me i would appreciate it. I am using macromedia dreamweaver to connect to an access database This is the error i am getting ADODB.Recordset error '800a0bb9' Argumen...
Hello, I am new to asp so if anyone would be kind enough to help me i would appreciate it. I am using macromedia dreamweaver to connect to an access database This is the error i am getting ADODB.Recordset error '800a0bb9' Argumen...
answer(1) view(120) status(
)
)
Keep focus in Listbox
I am working in a county jail and we are doing a database where you select the living unit location (example: 1A,1B,2A,2B) from a listbox. The problem is that most entries are multiples on the same unit. I would like the unit selected to st...
I am working in a county jail and we are doing a database where you select the living unit location (example: 1A,1B,2A,2B) from a listbox. The problem is that most entries are multiples on the same unit. I would like the unit selected to st...
answer(2) view(166) status()
)
newbie needs query help
I work for a nonprofit. Everyone has 10 jobs. I am the only person who uses/has used access. I have a donor database listing names addresses, and different fields for donations made/not made for each year. I do simple queries to pull names ...
I work for a nonprofit. Everyone has 10 jobs. I am the only person who uses/has used access. I have a donor database listing names addresses, and different fields for donations made/not made for each year. I do simple queries to pull names ...
answer(3) view(85) status()
)
Left Join
Hi, I am trying to do a left join in ASP but getting error message saying "Syntax error in From clause" The query runs fine if I have a record for a country in all the tables. But I have certain countries that do not have a matc...
Hi, I am trying to do a left join in ASP but getting error message saying "Syntax error in From clause" The query runs fine if I have a record for a country in all the tables. But I have certain countries that do not have a matc...
answer(1) view(413) status()
)
Linking a calendar control to a query
I want to be able to click on the date in a calendar control and the jobs scheduled for that day appear on the screen. Is this possible and how would I go about this. I created a query to pull the information I need and I attached that qu...
I want to be able to click on the date in a calendar control and the jobs scheduled for that day appear on the screen. Is this possible and how would I go about this. I created a query to pull the information I need and I attached that qu...
answer(1) view(909) status()
)
Error 438 on Error-handler!
I have the following code as error handling in a form that gives me Run-time Error 438 "Object doesnt support this property or method" with "Msgbox..." highlighted... Code: 'Error Handling On Error GoT...
I have the following code as error handling in a form that gives me Run-time Error 438 "Object doesnt support this property or method" with "Msgbox..." highlighted... Code: 'Error Handling On Error GoT...
answer(1) view(647) status()
)
Option Group reset
I have an unbound form with an option group among several other controls. I also have a "Clear" command button which resets the form and removes any entries in any controls. How can I reset the value of an option group (with ch...
I have an unbound form with an option group among several other controls. I also have a "Clear" command button which resets the form and removes any entries in any controls. How can I reset the value of an option group (with ch...
answer(2) view(127) status()
)
Running Reports with Criteria
How do I run a report based on a table, but with criteria? For example, I have a few check boxes on my table and I want to run a report of all the people who have the boxes checked. Thank you!
How do I run a report based on a table, but with criteria? For example, I have a few check boxes on my table and I want to run a report of all the people who have the boxes checked. Thank you!
answer(1) view(18) status()
)
Firefighter needs help with access problem
Hello, I am a firefighter and am trying to create a database for storing fire hydrant information and the yearly inspections that we do on the fire hydrants. The tables below are simplified, but should work for an example: Table1: Hydran...
Hello, I am a firefighter and am trying to create a database for storing fire hydrant information and the yearly inspections that we do on the fire hydrants. The tables below are simplified, but should work for an example: Table1: Hydran...
answer(7) view(47) status()
)
Form auto fill?
I have a database with a table of all our records. I created a form, and would like to be able to type in the last name in the last field and have it bring up the record. Also, this could be a problem because there are several people with t...
I have a database with a table of all our records. I created a form, and would like to be able to type in the last name in the last field and have it bring up the record. Also, this could be a problem because there are several people with t...
answer(1) view(179) status()
)
Weird!
I have 2 unbound boxes in the footer of my continuous form. Both total up separate sets of fields using DSum and do it correctly. I have used Conditional Formatting on Total1 to make the numbers turn bold and red whenever Total1 is greater ...
I have 2 unbound boxes in the footer of my continuous form. Both total up separate sets of fields using DSum and do it correctly. I have used Conditional Formatting on Total1 to make the numbers turn bold and red whenever Total1 is greater ...
answer(6) view(833) status()
)
Formatting Data in List Box
I have a phone number field defined in a table as text and use the input maks !\(999") "000\-0000 for entering and editing data. Is there a way to use a mask when using this field in a list box? It would be nice to be able to sh...
I have a phone number field defined in a table as text and use the input maks !\(999") "000\-0000 for entering and editing data. Is there a way to use a mask when using this field in a list box? It would be nice to be able to sh...
answer(2) view(314) status()
)
SubForm Criteria
I have a form with subform which use six fields on the form to determine what data is returned in the subform. As long as every field has a valid entry the data is returned correctly. What I would like to add to this is if a particular cri...
I have a form with subform which use six fields on the form to determine what data is returned in the subform. As long as every field has a valid entry the data is returned correctly. What I would like to add to this is if a particular cri...
answer(0) view(769) status()
)
A form w. critera for a query/ODBC Call Failed
Hi! I have a query setup that feeds off of three combo boxes on a form. It is setup to allow a user to search and calculate revenue for a selected time period by company, then department, then page. If all three or just company are selec...
Hi! I have a query setup that feeds off of three combo boxes on a form. It is setup to allow a user to search and calculate revenue for a selected time period by company, then department, then page. If all three or just company are selec...
answer(6) view(441) status()
)
looking for good tutorial on feeding a site with a database.
I am very new to ASP and Access. I need to learn how to create a database full of images and text to feed dozens of webpages for a new site I am doing. I have googled many times and can't really find what I am looking for. I've come acro...
I am very new to ASP and Access. I need to learn how to create a database full of images and text to feed dozens of webpages for a new site I am doing. I have googled many times and can't really find what I am looking for. I've come acro...
answer(5) view(497) status()
)
Message Box and After Update event
Hi I have form with a series of text boxes in which users can edit the data that is populated in them. For one of the text boxes I want to add an after update event, so that if the user changes the value in the text box, a message window ...
Hi I have form with a series of text boxes in which users can edit the data that is populated in them. For one of the text boxes I want to add an after update event, so that if the user changes the value in the text box, a message window ...
answer(1) view(849) status()
)
excel dao upgrade
Please help?! We just upgraded from 97 to 2003 version. This is a scheduler routine which auto imports an excel spreadsheet into our main db. After I upgraded it stops on with "compile error variable not defined" Also after the co...
Please help?! We just upgraded from 97 to 2003 version. This is a scheduler routine which auto imports an excel spreadsheet into our main db. After I upgraded it stops on with "compile error variable not defined" Also after the co...
answer(1) view(488) status()
)
declare variable
we upgraded to 2003 access. Now in a code getting the msg that I need to declare a variable for:xlexcel9795 here is how it is in the code. what do I put? FileFormat:=xlexcel9795
we upgraded to 2003 access. Now in a code getting the msg that I need to declare a variable for:xlexcel9795 here is how it is in the code. what do I put? FileFormat:=xlexcel9795
answer(1) view(231) status()
)
Form height
I've many items to be put on a form. However, I can't expand the height of the form. The max height I can get is 55.873cm. Could anyone please teach me to expand it? Many thanks.
I've many items to be put on a form. However, I can't expand the height of the form. The max height I can get is 55.873cm. Could anyone please teach me to expand it? Many thanks.
answer(3) view(799) status()
)
Populate an unbound text box
Hi, I have a form that has a list of sitting on when you select a sitting I would like to produce list of centres that are registered with that sitting. I would like to do this by having an unbound text box. I need to do it this way for pa...
Hi, I have a form that has a list of sitting on when you select a sitting I would like to produce list of centres that are registered with that sitting. I would like to do this by having an unbound text box. I need to do it this way for pa...
answer(1) view(287) status()
)
frontend 2003 - de-bug keeps popping up
We have a backend of 97 version and frontend of 2003. When the users try to cnt-break out of a query that is taking a long time the de-bug window pops up and then they hit yes and the database shuts them out. How can I keep this from coming...
We have a backend of 97 version and frontend of 2003. When the users try to cnt-break out of a query that is taking a long time the de-bug window pops up and then they hit yes and the database shuts them out. How can I keep this from coming...
answer(1) view(1,000) status()
)
Row Colours in Report
I got the following code from:- http://www.microsoft-accesssolutions.co.uk/alternate_row_colours.htm This is to give me alternating row colours in report detail section but cannot make it work. Please could someone tell me where I am...
I got the following code from:- http://www.microsoft-accesssolutions.co.uk/alternate_row_colours.htm This is to give me alternating row colours in report detail section but cannot make it work. Please could someone tell me where I am...
answer(4) view(726) status()
)
text field problem
Hi I need to insert some number into MS Access 2003 database as text. My problem is when I insert "3.8-4.0" it shows value "-0.2" and when I enter "1.0" it shows "1" in the database I am using ASP b...
Hi I need to insert some number into MS Access 2003 database as text. My problem is when I insert "3.8-4.0" it shows value "-0.2" and when I enter "1.0" it shows "1" in the database I am using ASP b...
answer(8) view(680) status()
)
Complex Combo Box Filtering
Ok, so I invoke your help once again. Here's the situation: I have a list of Crew Leaders. Each crew leader has the option of being the leader of up to three different types of crews, which is determined by checkboxes. In a separate for...
Ok, so I invoke your help once again. Here's the situation: I have a list of Crew Leaders. Each crew leader has the option of being the leader of up to three different types of crews, which is determined by checkboxes. In a separate for...
answer(14) view(63) status()
)
Find and Update
I currently have been set the task to update our inhouse database (Access 2003) with data from downloaded XML files. I have the database importing, and extracting the data into a new table. My problem is now I need to query the main table, ...
I currently have been set the task to update our inhouse database (Access 2003) with data from downloaded XML files. I have the database importing, and extracting the data into a new table. My problem is now I need to query the main table, ...
answer(1) view(13) status()
)
DateDiff decimal problem
I have a field on my form that uses the DateDiff function to calculate the difference between a Date Of Birth [DOB] and the current date. The only problem I am running into is that it inclides the age and a decimal point followed by up to ...
I have a field on my form that uses the DateDiff function to calculate the difference between a Date Of Birth [DOB] and the current date. The only problem I am running into is that it inclides the age and a decimal point followed by up to ...
answer(1) view(76) status()
)
Adding new reords
Hi all! I'm new to this forum. I have a question regarding adding additional records to my subform. I have an order form that contains a main form and a subform and they are link with a child and master link. The main form is where I input ...
Hi all! I'm new to this forum. I have a question regarding adding additional records to my subform. I have an order form that contains a main form and a subform and they are link with a child and master link. The main form is where I input ...
answer(2) view(221) status()
)
Combo boxes?
If I have 3 combo boxes that have autocomplete turned on, is there an absolute limit on how many records I have? Right now, I have approx. 30K. I expect to be at 40K in a couple months. Originally, I just wanted fast data entry. I did...
If I have 3 combo boxes that have autocomplete turned on, is there an absolute limit on how many records I have? Right now, I have approx. 30K. I expect to be at 40K in a couple months. Originally, I just wanted fast data entry. I did...
answer(6) view(324) status()
)
Combo box selection triggering 2nd combo box tables
I'm trying to get one combo box control what tables are available from another combo box. Example, combo box (a) includes numbers 1-5. Selecting (1) makes the data in combo box (b) specific to that selection. Selecting (2) makes the data in...
I'm trying to get one combo box control what tables are available from another combo box. Example, combo box (a) includes numbers 1-5. Selecting (1) makes the data in combo box (b) specific to that selection. Selecting (2) makes the data in...
answer(1) view(983) status()
)
search for barcode with scanner as input
I have created a form that I would like to search for a barcode by using a scanner as an input device. Does anyone know how to go about doing this? The form basically holds a subform of textboxes that have barcodes. I want the user to b...
I have created a form that I would like to search for a barcode by using a scanner as an input device. Does anyone know how to go about doing this? The form basically holds a subform of textboxes that have barcodes. I want the user to b...
answer(1) view(909) status()
)
Programming
Related Pages
- Date Query Question
- Filling in Blank fields with the digit 0
- Changeing feild in table annualy.
- dynamically add controls
- Selecting 'yes' values from checkbox in query
- Security problem. Logged directly in as admin
- How do you Link a Check box to formula
- Summing #s in a query
- Sum Totals in a report
- import Eudora emails
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