Search results

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)...

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...

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!)

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...

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...

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

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...

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()...

Wow! New forum decor, not been here for a while. :cool: I have the following code which I'm hoping will allow me to update a linked table to the path stored in a table: Option Compare Database Function relink() Dim dbs As Database Dim tdf As TableDef Dim strFileName As Path strFilePath =...

I'm currently using this module: Option Compare Database Option Explicit Global Const SW_HIDE = 0 Global Const SW_SHOWNORMAL = 1 Global Const SW_SHOWMINIMIZED = 2 Global Const SW_SHOWMAXIMIZED = 3 Private Declare Function apiShowWindow Lib "user32" _ Alias "ShowWindow" (ByVal hWnd As Long...

I need to open a form when a tables contents change. I'm only ever dealing with a few records and I want a form to be displayed when the tables contents are displayed? Anyone go any ideas? TIA

I have attached a database that contains a problem I've been tring to solve for some time. I have a table (tblInventory) and a form (frmFilter). The frmFilter has 6 check boxes and 7 combos. When the check boxes are true, the combos are enabled and these are bound to the relevant fields within...

Can I make a label display a text comment and then the value of a textbox on another form thats open? E.G. This problem has been solved (Form!frmProcess!txtSolvedTotal). Try again. TIA

I want to get the following code to change the forms back ground colour on load. Can anyone help? Private Sub Form_Load() Forms!frmTEST!txtColour.BackColor = 13408767 End Sub I tried: Private Sub Form_Load() Forms!frmTEST.BackColor = 13408767 End Sub But had no...

Has anyone got any sample DB's that use a 'Control Panel' for allowing the user of a DB to change certain features? I want to introduce a form that will allow them to enable and disable certain buttons and textboxes on other forms. Later, when I've got more time, I want them to be able to...

How can I run a .Requery event only if my form has focus? I currently run an OnTimer event to do the following: Private Sub Form_Timer() Forms!frmMAIN.Requery End Sub I want to only do the requery if the form actually has the focus. TIA

I'm using Office 2000 Developer and I have packaged my databases and other assotiated files so that I can install the application on a machine that does not have Access installed. The package is created successfully but when running the setup.exe on the client PC, I get the following error...

Is there a way to stop the scroll wheel on a mouse scrolling through the records on a form?

Has anyone come accross a way to burn a database to CD? Maybe a form that allows you to just say 'backup data' and it would be burnt to CD?