Search results

No, but thanks, I'll have a look

I want to create a form that will firstly display my client details (selected from one form and then automatically entered into my main form. This will create a new record. In the main form there will also be a subform. This will be related with the main forms data (one - many respectively)...

Thanks for your replies. So Rich, is this correct: Private Sub btnSortByMonthAZ_Click() Forms!frmSales!sfrmSales.SetFocus fldMonth.SetFocus DoCmd.RunCommand acCmdSortAscending End Sub I'm sure I've used this code in the past, but I can't find a project with it being used. Is it...

Sorry 'fldMonth' is a bad name for my control, but it is the control, if you see what I mean Thanks for the reply

Keep getting a runtime error 2465 - Can't find the field . . . This is my code: Private Sub btnSortByMonthAZ_Click() Forms![frmSales]![sfrmSales].Form!fldMonth.SetFocus DoCmd.RunCommand acCmdSortAscending End Sub I'm trying to set the focus of a field within a sub form so that...

Thanks Rich, works a treat

Actually, I've got it putting a £ sign in simply by doing this: ="Total Unpaid for" & [fldMonth] & " " & "£" & Sum([fldProfit]) The problem is the decimal places?

Thanks for your reply but the first thing I tried was to adjust the property for the data format and the decimal places in the Properties dialog?

How can i make the following result display the a pound (£) symbol and to 2 decimal places: ="Total Unpaid for" & [fldMonth] & " " & Sum([fldProfit]) This textbox currently displays in my report as " Total Unpaid for July 191.123 " (without quotes!)

I'll explain myself a little better. I understand how to create an MDE because that's what I always use for the end application. What I'm trying to do however is use the 'Pacakge & Deploy' Add-In that comes with the developer edition of office 2000. To create a package, you have to open the...

How do you package an MDE database?

I've designed an Access 2000 application which works fine on my system but on another system running windows 2000 and Access 2002, I get reference errors. When looking in the VB window at Tools, References - they are greyed out? Could this be a user login problem or an incompatibility between...

Is there a better way?

I have the following code for taking periodic backups: Function ImportInventory() Dim strHost1Path As String strHost1Path = DLookup("fldConfigValue", "tblConfig", "[fldConfigName]='Host1Path'") DoCmd.TransferDatabase acImport, "Microsoft Access", _ strHost1Path, acTable...

Thanks GHudson, Thats just what I need and I'm aware of when the date will change. Kind Regards, TAC

I wish to display the date and time of a tables modification attribute within a form, using code. Can anyone help me? :confused: TIA

Thanks Keith, I've just found the following: Screen.MousePointer = 1 'Only show windows pointer Screen.MousePointer = 0 'Hourglass state determined by Access This seems to to the trick although I'm sure your solution would have worked too. Thanks, TCieslik

Is it possible to use code to control the state of the Mouse/Egg Timer? I'm running an OnTimer event every 750ms in my form and although the form functions perfectly, the egg timer is very annoying. It's made worse if the application is run on a lower spec PC. I guess this is due to processing...

Thanks for the reply Tim K, I do understand these file path conventions, but this does not help my problem. As I explained, I'm using a 3rd Access application to do the 'Backing up'. Anyway, the problem is solved. I was tring to do too many things with one bit of code. I now do an import of...

I have a DB that acts as a 'Backing up' application. I want to export the table in one database on my network (mapped drives) to another DB on the network. I've tried this code, but it will only work on the PC where the source DB is, and I don't want that: Function ExportInventory()...