Search results

I have a main form (A) with a subform that is another form with a datasheet(A_SUB) On the form A is an undo button which rewinds any changes that occur to A that I do not wish to commit. However when I make a change to A_SUB the changes are not rewound. I considered implementing an UNDO for...

I have several reports in my system. Some are landscape and some are portrait. Occasionally the landcape ones switch to portrait taking up two pages each. In preview mode it is not so bad that the user can reset the page size, but when one is sent to print this is most certainly annoying...

Which ones are the best?

I am running access 2000 9.0.2720. I wanted to create an MDE file but every time I attempt I get the message 'unable to create an MDE file'. Any advice?

The following statement returns NULL Dim str As String Dim n As Variant str = "RemitDate >= #" & Forms![Report Menu].FromDate & "# AND RemitDate <= #" & Forms![Report Menu].ToDate & "#" n = DSum("GSTPaid", "queryJobRemittance", str) yet however when I run the query ie SELECT sum(GSTPaid)...

Hi, I have a table in a form. I want to hook onto the event that occurs as each and every row is being loaded (ie to change the colour for a row). Which object and which event? Thanks

Hi, I am inserting records into a table where one of the fields I want to insert is a date value from a form. When I run the query without inserting it it works fine. When I change the value into some other type (a string) it also works fine. I have tried it with a date 05/05/05 so it has...

Hi, I am inserting records into a table where one of the fields I want to insert is a date value from a form. When I run the query without inserting it it works fine. When I change the value into some other type (a string) it also works fine. I have tried it with a date 05/05/05 so it has...

HI, I have a table called cust_order, with fields: orderNo, product, ... I have a form which updates these values. On the 'enter' event of a button to 'update changes' I collect the stored values cust_order and compare these old values with the new values. I do it using the dlookup command...

The snipet below returns only a single record. I want all the records. I am not sure how to get the results from the query or the syntax. This is what I want: Select location from client_loc where clientID = FORMS!job.ClientId Thanks --------------------------------- Private Sub...

Hi, I have two combo boxes where the first lists values in one table. On selecting one I want a second combo populated with records in another table where foreign key = primary key. Obviously the query is select location from client,location where client.client = location.client However I...