Search results

I am trying to calculate the average patients age from 2671 records using this SQL: SELECT tbl_Customer_Details.DOB, CalcAge([DOB]) AS Age, DAvg("[Age]","qryAvgAge") AS Average FROM tbl_Customer_Details GROUP BY tbl_Customer_Details.DOB, CalcAge([DOB]); why am I getting the result...

I have converted my 2000 mdb file to a 2002 mde file. When I run the mde on another pc using 2003 In ' get #name? ' error on a control (Age) that holds a persons age calcultated from a DOB control ( DOB) which is populated from a popup calendar. The age is calculated using the following...

I have a parameter query that requires the user to input a start date and end date into dialog boxes generated by the query. My question is: it possible to have a date picker control actually on the dialog boxes when they show for a date to be entered, or is this only possible when using a form...

With the help and support of this forum I have managed to Build my mdb application. So far I have managed to: Build the thing Turn it into an mde turn off shift bypass hidden toolbars /menus etc hide tables I need to log on/ off done can deliver it via cd self extracting installer as an mde or...

Hi all I have got a problem referencing some fields for a report, can anyone help solve this: Main form with 2 subforms on tabs, subfrm1 and subfrm 2. Subfrm1 has some controls which contain dates entered by the user. subfrm2 has some controls that are populated with the dates from subfrm1...

I just wanted to say... what a wonderful resource this forum is, without it and the willingness to help and patience of the members and moderators to help others I would have given up looooong ago on my project. It is however becoming addictive, not a day goes by without my forum "fix" and I...

Hi All, I'am using the following code to update a table (tbl_CDT) on a NotInList event of a cboBox (CDT) I keep getting a SQL syntax error message, can anyone help resolve the code please Private Sub CDT_NotInList(NewData As String, Response As Integer) On Error GoTo CDT_NotInList_Err...

Hi All,:confused: need some code help again, I dont seem to be able to get the hang of message boxes!! The code below takes the path to a mdb file which is stored in a text box on my form, it then deletes an existing table -Expire-and replaces it with a new table also called Expire from the...

Is it possible to delete an entire seperate database from within a database via code after an uodate procedure has been carried out on a click event of a commad button, what would the code be to acheive this if its possible??:rolleyes:

Can anyone help with this code please. I keep getting Error 13, type mismatch on the on click event of a Command button. Private Sub Command6_Click () Dim tmpFilePath AS String tmpFilePath = Me!Text1 DoCmd.DeleteObject acTable, "Expire" DoCmd. TransferDatabase_...

Hi All, Is it possible to have just one instance of this message box fire when one or all or any number of the flags are triggered. At the moment if 2 flags are set then 2 messgage boxes appear,if 3 then 3 messages etc. My code at the moment is below to trigger the message box, hope I make my...

Is it possible to fill an unbound text box in a seperate form with some text "Warning.HIGH RISK" on the click event of a checkbox on a different form?

Hi everyone, does anyone know how to remove the little replication icons next to the db objects when a replica is converted back to a design master. I know there is a way cos i've seen it here before but I can't find it searching. Thanks.

After working great for 12 months my db has suddenly stopped working tonight! after opening on to the first form and clicking off any field I get "Invalid Data Format" error message pop up and transfered to the code windows. Access then tells me it does not recognise the code and shuts down ...

Hi, I am just about to install a database on another computer 300 miles away. The db has an expiry table which prevents access when a certain date is reached. Is it possible to update that table via an update on CD or email sent to that person with a new date so they can continue using the db...

Hi All, Can anyone help me count postcode instances. I have a query that looks at my customers table (tbl_Customer_Details) post code field (PostCode), at the moment I have got it to strip out the right side of the postcode leaving me the left district side eg. HG12 8EN becomes HG12. I would...

Hi All, Can anyone help me count postcode instances. I have a query that looks at my customers table (tbl_Customer_Details) post code field (PostCode), at the moment I have got it to strip out the right side of the postcode leaving me the left district side eg. HG12 8EN becomes HG12. I would...