Search results

Hello, I have a table exported from excel. I intially imported this in to access to form a list of due dates for services. Every week I get and e mail with the updated version. I am trying to figure out how to update the dates in the 1st table with the new weekly ones. I can't get it to...

Hello, I am trying to calculate the percentage of occurence in a report. I am using the following code in the data source for the text box: =(Sum([Text6]="Boblat")/([Text12]/100)) When I run the report the percentage is correct it is just a negative figure. how can I correct this problem...

Ok, I have a subformt hat is populated by a combo box. When the user selects data from the combo this then lists a customer number, models, and date in the subform. The selection from the combo box executes a query based on customer name in combo box. The subform displays the models and...

Hello, I have been playing around to see if it is possible to operate a combo box as a one shot operation. I.e you make a selection from the combo box then the combo box is disabled. Only prob is that I can't figure out how to do it. Possibly by using a message box to see if selection is...

Ok, I have a lovely database setup for call loggin. I have a table that contains a primary key [autonumber], with all the details about a call e.g time of call [time short] date of call etc. I would like to add a call refernce field that is automatically generated for each new record. But...

Searched through for help but to no avail. I'm usnig 2 combo box the with the following code in the after update event of the first/master combo box: Combo34.RowSource = "Select tblMasterDB.Instrument " & _ "FROM tblMasterDB " & _ "WHERE tblMasterDB.Hospital Name = '" &...

Hello, I have a couple of buttons on a form that I am havinga little trouble with. The first button increments an integer variable which changes the colour of a box dependant upon the value. When a new record is opened I want it to be 0 which sets the colour. So on the form load event I have...

Ok I've searched through and read about normalization can someone just have a quick once over my grasp of this concept. I am designing a database for service recrods, the database will detail Customer contact details, service records, location and instruments. so I have 4 tables: 1 listing...

Hello (Again!) I have a form that is mainly used for data entry (for call logging). Ideally it will be linked to 4 different tables, however I need to get the basics working. My new problem is being able to look up data that is selected in a combo box to see if it is out of date. I shall...

Hello, Hopefully someone can help. I have a table that is used to monitor calls, there is on field called StartOfCall and another called EndOfCall. All I am trying to do is to put a button onto the form so that when you click on it it enters the current time into the start of the call field...