Recent content by tacieslik

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