Search results

Hi, Is there an easy way of checking via VB if a query exists? Regards Peter

Hi, Is there a way to backup the entire database using vb. The backups I have found only appear to backup data not the changed code in the current session. Thanks for any help Peter

Hi, Can you help me. I need to count the number of invoices to a client for a report. eg fldclient fldInvoice# 1 101 1 110 1 123 2 113 2 115 count client 1 has 3 invoices client 2 has 2 invoices etc The dcount does not appear to be the...

Hi, This may not help but I had the same issue so I copied all the records to a blank table. Did a count of now many records there were and looped to add (inserting a 'z' so that these records appear at the end of the report) the difference to the table always had the same number of records...

Hi, Hope you can help. I have a loop that that produces the same report with different data, however ms access appears to only allow one instance of a report name. Is there a way around this. Thanks Peter

Hi, Thanks Peter

Hi, Recordset worked like a charm. Thanks a lot. If possible can you tell me the difference between the two if it's not to much trouble. Thanks again Peter

Hi, Thanks for the reply. Dim rs As DAO.Recordset Set rs = Me.RecordsetClone rs.MoveLast rs.MoveFirst Dim idx As Integer For idx = 1 To rs.RecordCount aa = Me!Text6 ' textbox a1 = rs!ID ' record ID MsgBox aa & " " & a1 rs.MoveNext nn = nn + 1 Next idx...

Hi, I have I think a strange loop problem. I have a loop that runs though the records on my form and is working correctly for any data fields but it will only pickup the first textbox field and not change for the following records. For example if I display (msgbox) the first record with the...

Hi, Thanks for your help. I figured it out this morning. Edited the properties and added the extra field to the Query. Thanks again Peter

Hi, I think the answer will be very simple but I can only seem to graph one field using the Graph wizard. I have a table that have running totals: Date-----Sales ---- Budget 1/8/2013 0 2000 2/8/2013 2500 4000 3/8/2013 2500 6000 4/8/2013 4000 8000...

Hi, I need to check each field in a record for data as I loop thu a table. (recordset) For example Record looks like: Field1 Field2 Field3 Field4 etc - Field names G Smith 23 Blackburn H Jones 13 Riverside J Black...

Hi, Our work 'losses' documents (doc,xls,pdf etc) all over our server, I would like to start a document control within ms assess. I was thinking that I enter the path to the document. When I click on the path the document will display. That's my idea but am open to any suggestion. Thnaks Peter

Hi, Thanks pbaldy, could I push my luck a little and ask how I would code below Scan barcode Add new record to a table empty field Scan next bar code ... ... Then I would press enter to finish Thanks Peter

Hi, I maybe pushing my luck but does someone have a simple example MS Access database that reads a barcode reader and loads the barcode into a table. Hoping you can help Regards peter

HI, Hope you can help. I would like to create a loop where I change the VB line with the loop number. IE rs2.AddNew rs2![SDPhone] = Val(stext) rs2![SDQty] = rs1![P1Qry] rs2![SDName] = rs1![P1Name] rs2![SDSKU] = rs1![P1SKU] rs2![SDPID] = rs1![PID] I would like to change the P1...

Hi, Can someone help. I have an Access 2007 file I need to loop though to send out emails in Outlook.'My issue is that I need to change the Outlook account depending on the record. I currently use docmd sendobject but I cannot find how I can change the Outlook Account. Thanks for any help. Peter

Hi, Thanks to you all Regards Peter

Hi, I have a query the appends an access database from an excel spreadsheet (via a link in Access) taken from another program. My problem is that one of the excel columns contains both text and numeric data and I keep getting a 'data mismatch'. I would like to convert both to text I have tried...

Hi, I have a text field that looks like John Smith 34 Black Street Liverpool Queensland I need some VBA to read the text, line by line, as I have to insert each line into other fields. Appreciate any help Peter