Search results

I have a report that gets it data from a query. One feild in this query (Expr2) is an expression based on two date feilds in two tables. I want the report to group this feild into month so have created a group header based on Expr2 and put an expression in the On Format feild...

Guys, I have the following expression in a query: The "required" feild in this query always has data in it, "oddespatchdate" feild sometimes does, sometimes does not depending on user input. I want the "required" feild to show if "oddespatchdate" is blank but the "oddespatchdate" to show...

Hi Paul, Could you expand on that a little? As I explained I am a novice and using the nz() function means nothing to me. Thanks JohnG

I have a report thats data source is a query. This query has two date feilds (DateRequired and DespatchDate) DateRequired always contains data but DespatchDate can be blank or filled out depending on user input. Currently the report shows the DateRequired feild but a user has asked me if it...

Thanks for your input guys. To be honest I am lost here, I know nothing about VBA code, I copied this code from another part of the DB and am trying to learn as I go. (steep curve!) I have no idea what an undo is! I tried the sample code but it threw up a compile error. I put in Cancel=True as a...

Here it is: Private Sub Pack_Number_BeforeUpdate() If MsgBox("Are you sure you want to CHANGE this Number?", vbQuestion + vbYesNo, "System Message") = vbNo Then Exit Sub

Guys, Still having an issue with this code. If I change data in the feild and then hit enter or move the focus to another feild I get the system message prompt OK but if I select the "NO" option the data still remains changed. I want selecting NO to revert the data back to its original form...

Hi Shadow, Thanks for your email. I am a bit confused to be honest. The report is already created and the feild I want to format and group on is called "Required" I have set the grouping option for this feild to "yes" for this feild but when I tried to change this feilds group interval to...

Guys, Gals, I have a report that I run from a command button on a form. The record source for this form(subform) is a query. My data in the backend table and the query are formatted as dd/mm/yyyy, which is how we want it to stay. Problem is my boss wants the records in his report shown...

Ah!, thank you! JG

Guys and Gals, I want to add an event procedure to a feild in a from so that if the data is changed a yes/no system message appears asking the user if they are sure they want to change the data in the feild. If they click yes the change is accepted if they click no the feild reverts to back...

Guys, We have a MS Access database at work for our order and stock tracking. I have done some of the design with a local programmer steping in and doing the rest. The database, as it is, works well and has been very stable but our big issue is the database speed. The database is split into...

Guys, I have a report that has three unbound text boxes and three bound customer address feilds. I am trying to put in some code that basically says if there is no data in the any of the bound customer address feilds move everything up a text box to make the report look pretty. Heres the code -...

Guys, I have a subform that has combo boxes set behind visible data feilds. When I tab into or click on the front feild I want the combo box in the background to show so the user can make a selection from the list. Once the user tabs out off, or click out off the cell, the combo box...

Hi, Sorry about the upside down PDF! Could you explain what you mean a bit more, I am new user and don't really understand what you mean. Thanks JG

Guys, I have a form/sub form where we enter order information. As you tab through the sub form a combox appears in each feild to choose data from a list. When you tab/move out of the feild the combo box disappers. This works well except that as you add lines to the order and if you pass the...

Thanks Bob, worked a treat! JohnG

Hi Bob, Just checked the report and it worked fine. Just one thing - I see it returns formatted as "August", if there anyway to make it return in capitals formatted as "AUGUST" Thanks JohnG

Thanks Bob. JohnG

Guys, I have a report that looks up a general date feild in a table. At the moment the report reads, as an example "11/08/2009" I want it to read "August" or if it was 11/09/2009 the report would show "September" Is this possible? If so how? Thanks JohnG