SQL
is it possible to have a where sql statement that is open ended. I have notice that there are time that parameter box pops up with some the Access pass-through queries that I have. Is it possible with SQL to be able to have a box pop up that would ask for a specific input to the...
is it possible to have a where sql statement that is open ended. I have notice that there are time that parameter box pops up with some the Access pass-through queries that I have. Is it possible with SQL to be able to have a box pop up that would ask for a specific input to the...
590 pts.
Closing Open Databases
I've been doing access for years, but only really developing one mdb at a time. My new job has me working on this product called UA, which does some pretty slick stuff that I haven't seen before.. Always fun to learn. Anyway, this product has multiple mde's that all are "called" from a main System...
I've been doing access for years, but only really developing one mdb at a time. My new job has me working on this product called UA, which does some pretty slick stuff that I haven't seen before.. Always fun to learn. Anyway, this product has multiple mde's that all are "called" from a main System...
How do I set decimal places with VB Access
I am using Access 2000 database for calibration control of measuring instruments. i.e. micrometers, calipers etc. The precision of the instruments varies and the decimal data fields in the table are set to Auto to minimize the stored values without changing the accuracy. I want to change the number...
I am using Access 2000 database for calibration control of measuring instruments. i.e. micrometers, calipers etc. The precision of the instruments varies and the decimal data fields in the table are set to Auto to minimize the stored values without changing the accuracy. I want to change the number...
Date problem with Delphi 7
I am trying to select records where the date is smaller that a specific date by using Delphi 7. The data is stored in a MS access 2000 database. dtsdate.DataSet := qrydate ; qrydate.Active := false ; qrydate.SQL.Text := ' select * from datum where datum < 1994/02/05' ; qrydate.Active :=...
I am trying to select records where the date is smaller that a specific date by using Delphi 7. The data is stored in a MS access 2000 database. dtsdate.DataSet := qrydate ; qrydate.Active := false ; qrydate.SQL.Text := ' select * from datum where datum < 1994/02/05' ; qrydate.Active :=...
adding hyperlink
I have created columns in the query for links to pdf files. Each one belongs to an employee. My question is how do I create the link to showup on the form for each employee? The links belong to certain employees while others have no link. I am currently running Access 2000.
I have created columns in the query for links to pdf files. Each one belongs to an employee. My question is how do I create the link to showup on the form for each employee? The links belong to certain employees while others have no link. I am currently running Access 2000.
creating reports with forms/subforms
I have created a report that is linked to the form. When I click the preview command button it asks for Emp. ID I enter in the ID Number and click ok. The print preview screen shows up with nothing on it. How can I get the data to show up on the report? and when I create complete report how can...
I have created a report that is linked to the form. When I click the preview command button it asks for Emp. ID I enter in the ID Number and click ok. The print preview screen shows up with nothing on it. How can I get the data to show up on the report? and when I create complete report how can...
Allow Additions Property on Subform In Form View in Access 2000
I have a main form and a subform in access 2000. I have set both the properties to NOT Allow Edits, Or Deletions, but Yes to allow additions. However, when I open the form in form view the property for allow additions changes back to no. I am able to go back and change the property in form view...
I have a main form and a subform in access 2000. I have set both the properties to NOT Allow Edits, Or Deletions, but Yes to allow additions. However, when I open the form in form view the property for allow additions changes back to no. I am able to go back and change the property in form view...
Locking Forms in Access 2000
I am using access 2000. I have created a form based on a table filled with tons of information. This is a multi user form. At the end of all of the records a blank form is presented so that the multi users can enter their appropriate information. However, some of the user are going through and...
I am using access 2000. I have created a form based on a table filled with tons of information. This is a multi user form. At the end of all of the records a blank form is presented so that the multi users can enter their appropriate information. However, some of the user are going through and...
Formatting a subform for printing in access 2000
I am trying to print a form in access 2000. The form consists of a subform. The problem is when I print, the name of the subform is printed at the bottom of the fields on the subform. The name of the subform appears whenever there is a blank field at the end of the subform. I Don't want the...
I am trying to print a form in access 2000. The form consists of a subform. The problem is when I print, the name of the subform is printed at the bottom of the fields on the subform. The name of the subform appears whenever there is a blank field at the end of the subform. I Don't want the...
Switch between two options in Microsoft Access 2000 text field
I am an access programmer, not much used to with the VB codes. I am using the wizards instead. I have a new project where in I want the secondary level users to check the data fed by the primary users. The findings of the primary user will be available in the new screen for the secondary level user...
I am an access programmer, not much used to with the VB codes. I am using the wizards instead. I have a new project where in I want the secondary level users to check the data fed by the primary users. The findings of the primary user will be available in the new screen for the secondary level user...
How do i have access fill in a field in the form in opening with data from the parent form
My first question please feel free to point out to me if i need to do any of this differently I am looking to create a button that opens an existing form with a new record and inserts into a field in the new record data from the parent form. We have a system where information is distributed to our...
My first question please feel free to point out to me if i need to do any of this differently I am looking to create a button that opens an existing form with a new record and inserts into a field in the new record data from the parent form. We have a system where information is distributed to our...
mixed 2000 db and 2007 mixed datepicker results
I had an old access database (2000) and ported it to access 2007 all well and good then created a new date field in my form, now i get the datepicker option for the new field but none of the old date fields. any ideas how to get access 2007 to give date picker to my old date fields, i have already...
I had an old access database (2000) and ported it to access 2007 all well and good then created a new date field in my form, now i get the datepicker option for the new field but none of the old date fields. any ideas how to get access 2007 to give date picker to my old date fields, i have already...
Amending a Product Price without altering existing orders in Microsoft Access
Platform; Windows XP Microsoft Office - Access 2000 Adapting the example database that was supplied with Access - Northwind Sample Database. I adapted the above sample database back in 2003 to my own database but have now hit a snag and i am unable to rememberor or find the solution. Currently,...
Platform; Windows XP Microsoft Office - Access 2000 Adapting the example database that was supplied with Access - Northwind Sample Database. I adapted the above sample database back in 2003 to my own database but have now hit a snag and i am unable to rememberor or find the solution. Currently,...
permission to open database
ACCESS 2000 which we used to write two databases. We added a new user, and correctly added the group. Then the next morning and every day since we can not gain access to the database. There are 3 user computers. 1 user reads the reinstalled ACCESS database fine, the other two can't gain...
ACCESS 2000 which we used to write two databases. We added a new user, and correctly added the group. Then the next morning and every day since we can not gain access to the database. There are 3 user computers. 1 user reads the reinstalled ACCESS database fine, the other two can't gain...
Problem deleting an object(form) in Access 2000
When I try to delete a form that is visible in the object list a message 'could not find the object' is being returned. I have tried compact/repair and decompile on the database to no avail. Any ideas....
When I try to delete a form that is visible in the object list a message 'could not find the object' is being returned. I have tried compact/repair and decompile on the database to no avail. Any ideas....
Date Ranges in Access 2000
How do I show multiple date ranges in Access 2000. I need to see counts of items that are 0 to 15 days old, 16 to 30 days old and so on, on my reports?
How do I show multiple date ranges in Access 2000. I need to see counts of items that are 0 to 15 days old, 16 to 30 days old and so on, on my reports?
Add module to remote access database
I have 100+ access 2000 .mdb's that I need to add a specific module to. What I want to do is loop through all mdb files in a specific directory and add a standard module to each one. Any ideas as to how to accomplish this from within access vba would be appreciated. I intend to do this from within...
I have 100+ access 2000 .mdb's that I need to add a specific module to. What I want to do is loop through all mdb files in a specific directory and add a standard module to each one. Any ideas as to how to accomplish this from within access vba would be appreciated. I intend to do this from within...
limit number of users in access 2003
I converted access 2000 to access 2003 and I did the front end/back end approach. I need to limit the number of users accessing the front end so it doesn't lock up the application and not populate the look up table...I inherited this application
I converted access 2000 to access 2003 and I did the front end/back end approach. I need to limit the number of users accessing the front end so it doesn't lock up the application and not populate the look up table...I inherited this application
access2k unicode text column even # of bytes error
a certain row(s?) in an access2k table is corrupted. it causes the application to fail quite often requiring a messy procedure of bringing it up to date each time and it's been like this for years so no older backup exists. archive and fix fails for the same reason (unicode text column width must...
a certain row(s?) in an access2k table is corrupted. it causes the application to fail quite often requiring a messy procedure of bringing it up to date each time and it's been like this for years so no older backup exists. archive and fix fails for the same reason (unicode text column width must...
Save Access 2007 format as 2000 format with VBA
how can i save the curent database as a 2000 format with vba
how can i save the curent database as a 2000 format with vba
