Search results

Hi, Thanks for the reply. Entered as suggested. And got the attached error. I tried changing the image and is now image49 Me.[Image49].Visible = (Me.[Surname] <> "a") Is it something I have typed? Peter

Hi, I am trying to print business cards but need to 'switch' off the logo (image) depending on the field [Surname]. (Please see attached jpg) My iif statement is as follows which I have placed in the image Control Source. iif([Surname] = "a",[Image42].visible = False) However it does not...

Hi, I am printing membership cards with a logo(Image). However we use the same A4 card sheet over and over (as we may only print 2 at a time) so the the top of the sheet may have a couple of cards missing. So the next time we start to print on maybe the 3rd position on the sheet. (Dangerous I...

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