Hi
I have an Access database which I am trying to migrate to SQL Server 2000 for the back end, but keep the front end in Access 2003 for now. We have a query which runs and selects the las...
I'm sure this is easy just never done it before. I have a bound form and want to select a value from a combo box and have the form go to the record associated with the combo box value by way o...
I have a problem with a pair of combo boxes that I am trying to use to query a table based upon the selections made in said combo boxes.
route_combo selects the distinct route from table In...
For my department I built a simple MS Access database.
It contains a form with the ActiveX Control Microsoft Date and Time Picker Control 6.0
A coworker of mine can access the form but t...
My question is similar to question 21687496 but not exactly the same. What I'm trying to do is actually simpler but I'm still having trouble.
All I want to do is execute a stored procedure...
I have a fairly good database set up with my entire inventory. The system allows my workers to look up parts, to determine whether we have them in the shop. I would like my Form to have some l...
How can I (manually, in design view) associate a label control with a textbox control, so that (in design view) they both move together?
For Access 2003, I just want to ask here - because if there is a way Experts will know. Is there any way to color an individual control that is on a continuous form where all of the controls...
Hi,
From memory I need to use a DLookUp in the control source of the text box yet I can't recall exactly how to do this.
The expression building gave me the following which returns #Name...
I am working with Microsoft Access 2000. The porblem I am expericing is with a subform. I am trying to use the gotorecord method to move to the next record in the subform. When I run the co...
Hi there. I'm looking for a solution to change the advanced printing preferences for the Microsoft Office Document Image Writer programmatically. The default file output format is "MDI". I ...
I don't understand what causes this, since I have not added any code yet, and it seems to be an issue with the sub-form or its detail properties, however I have attempted changing each by tria...
My form has bound textboxes which I would like to limit to 2 decimal places during the data entry process and not "formatting" afterwards.
The field in the table set to Double.
The form fi...
This is driving me bonkers! I have an Access 2007 database to track engineering requests. I've completed 3 sections and now the 4th section (other than storing different information, they al...
Hi,
I have table and form called CUSTOMER. when user want to add new cusomer they first need to go manually in CUSTOMER TABLE, Go to the Last Record, and get the available number as Cust_ID ...
Hi,
I have trouble with an Insert command when one of the fields being inserted is a DateTime Field. Here is my code:
command.CommandText = "INSERT INTO Book (UserID, CardID, Gr...
Hi
I have a simple Access form connected to a backing table.
Is there a simple way to make certain fields mandatory on the form
entry without having to do this in the backing tables
How do you change the alias name in a query object via VBA? You might ask why; I have one form that I want to display the results from multiple query. Each query has different fields name and ...
I have a form/subform linked by Organization_ID. The subform populates the Donation table. The filter is working fine but I would like it to default to a new record in the subform when the c...
What I want is to require the user to enter 1 address(in a sub form) before leaving the main form. All but line 2 of the following code works if the cursor is on the 1st record. However if ...
I want to create a command button on my access form that when clicked opens a folder on my directory that relates to the record currently being viewd. The name of the folder is the same as one...
I have a form - frmMain I am using for data entry. Simple, 1 text box, 1combo to look set an entity type.
Then I have a subform fsub, which shows the same two columns. I can add data and it...
I am using a calendar (ocxCalendar) to enter dates into a form and the date is currently being displayed as 08/04/2008.
I need to be able to change this so that the date includes the day. S...
I need to get the value of a specific row from a combo box to be inserted in the following query. The value is for Expr6. I've tried this
"Forms!Booking_EventDetails![LastofBooking ID]!Row(...
I have an application that was orginally designed in Access 2000 and have updated so that it runs under Access 2007 (.ACCDB). But, when I create the .ACCDE for production it doesn't run. The f...
