Search results for query: *

I need a query that sorts data into 14 day blocks and then displays the results in a stacked bar chart? The data is continuously updated so I require the query to constantly sort the data without any changes to the original query.

I know there have been questions on this subject previously however the fix doesnt seem to work for me. I have data in a field like AD/DHC-8/1 and AD/DHC-8/100, when I print the report from this data the items are not listed sequentially like I need. I cannot edit the data as its imported from...

I have a document that is over 300 pages long, each page contains a unique page number. I need to link these pages back to a page at the begining of the document. Anytime I change the page status I would like the front document to be updated automatically. If anyone can help it would be greatly...

I have just set up a basic Audit Trail using the code shown below. However when I go to the underlying table the data isnt visible, I need a function that will allow the users to print the data from the underlying table if required. Any help would be appreciated. Here is the code used: Public...

This may seem to be a simple job but I cant seem to get it to work. I have a database that is used by aprox 10 users. I wish to place this database on a network and implement full security. However when I move it to the network how do I set up the security levels. I have the system working on my...

I have created a pop up form that is related to the main form. However when I add a new record to the main form the subform does not automatically get updated. The Main form has a field called serial number, and I have created a relationship with the new table for the pop up form that has a...

I have created a database that has ole objects embeded into it. However when I try to open the files on my computer I get the following message. A problem occured while ms access was communicating with OLE server or active x control. Close OLE server and restsrt outside of MS access then try the...

I am having problems with making a subform visible or not depending on the selection of a check box on another subform. I have a master form calle frmEO and then a subform that has a check box, check27. when the form opens if check 27 is selected then another subform is visible. The master form...

I have a form that uses Auto Numbering. When I open the form it always goes to a new record. If I sort the field I can get to the first record, when the form is closed and re-opened the sort order is no longer valid and I need to replicate the previous sort. How do I get the form to retain the...

I have a form that contains 3 combo boxes that are used as the basis for a query. The problem I have is 1 or more of the combo boxes can contain a null entry. How do I get the query to search for the 3 parameters even if 1 is empty? I have tried using combinations of the And/Or criteria and none...

I am using Access 2002 and have a problem with the On Not In list event. I have a combo box that I would like to add new entries to when required. I have tried using the DAO VB scripts but it doesnt seem to work. The combo box gets its values from an underlying table and the form it resides on...