Search results

I have a query where one of the fields is: Inv: Inv1 & "/" & Inv2 & "/" & Inv3 This works fine and displays 3 numbers like this: 234/215/235 However, the Inv1, Inv2 and Inv3 fields are actually comboboxes which store the ID field of the lookup table. So, instead I want to do show this...

Actually, I have just worked out a large part of it. I can use an iif function in a column and if it finds a particular value, set the field value 1 or 0 if not found. Then the report can sum to get a count. I also need to calculate an average of a field, but only if there is a value in there...

I'm creating a report that will show Jan-Dec in the first column. The next column shows total record counts for each month. Next, I want to show the record counts for each month but filtered by location. i.e. first column is just the total, but second column is a filtered total. Can I do that...

I am using Access 2007 and since there are about 30 tables, it would be extremely slow to update each table link manually, one at a time. Can I just delete the tables and then go External Data > Access and link to the tables that way? Or will deleting the tables and linking again like that...

Brilliant idea Dave! I was just thinking about putting the front end on the server and developing on there but your idea is far superior. One issue I had with the linked table manager was that when I tried to update the location of the tables, it was asking me for the file location of each...

Thanks for the suggestions Pat. I've already compacted and repaired the front and backend. I tried the printer thing and that didn't solve it. However, I have discovered precisely the moment it happens. If everybody else is logged out of the database, the an existing Form goes from design view...

When I clicked Create blank Form or try to just go to design view in my unbound form, it takes forever to load, maybe 20-30 seconds. Why? The front end is on my desktop, with the backend on the server, which is about 90MB in size. I am using Access 2007. Is it anything to do with it trying to...

Thanks for that. I had a look but I'm still struggling. I've tried this code that is triggered by the afterupdate event. Private Sub SearchByJobNo_AfterUpdate() strCriteria = CLng(Me.SearchByJobNo) If strCriteria = "" Then MsgBox "You have to populate GovenName and Surname first?!"...

I have a field in the header called SearchByJobNo. I want to click in there type in the Job No and it will search on the Job No field when I hit enter. Unfortunately, the Job No field is not unique. So when you hit it again, it should then go to the next record with the same Job No. Any easy...

I have tblClients and tblOrders, with a Main and Subform accordingly. I would like to click a button when on a particular client record and then this will create a list of items ordered with the order status set to Not Sent and put them into a memo field on the main form. Output to memo field...

I have Access 2007 in a multi-user environment and we need to lock the edited records. The database is split into a front end and back end. Do we apply the record locking settings to the front end or back end? Thanks, Dave

I have a subform in Access 2007, which was created using a wizard. When I click any of the fields, it highlights a rectangle that is larger than the field itself and encompasses the label above it in the Form header. It is like a dotted line around it. What is this? How do I add/remove this...

Sorted! Highlight the controls you want to remove the anchor for, then click Arrange>Remove (under the Control Layout group)

After some research, I think it has to do with Anchoring. But I have a list of checkboxes and their labels. How can I have more than 1 on each row? I can't seem to drag them to do that. Is there a way to remove anchoring?

I am having trouble to get to grips with the Access 2007 Form. In earlier versions, I could rapidly create attractive looking Forms, but the 2007 version seems to have a mind of its own! I have a Form in what I think is design view, although the top left toggle button shows View. When I try to...

I fixed this by changing this line: DoCmd.TransferText , "Import Spec TransferText Test", "tblStage1PGNImport", strDataToImport to... DoCmd.TransferText acImportFixed, "Import Spec TransferText Test", "tblStage1PGNImport", strDataToImport ...and it now works! :)

I have the following code to import some data: Dim a As String Dim strDataToImport As String Dim strOpenFileName As String Me.txtCount2 = "" strOpenFileName = OpenFileName strDataToImport = strOpenFileName DoCmd.TransferText , "Import Spec TransferText Test", "tblStage1Import", strDataToImport...

Fabulous, thank you! Never knew that one. Since I will be making a large number of queries, is there any way to do this via code? It would save me from having to edit each query I make and I will be making a lot of them! I mean perhaps I could make a temp query somehow and use code to add the...

I use the following code to export a query to a text file: strQueryToExport = Me.lstQueryList.value DoCmd.TransferText acExportDelim, "PGN Export Specification", strQueryToExport, strFile, True A typical Query may have 10,000 records, but this is too many for me. Is there any way to limit the...

Thank you!