Search results

Hi, Ive been using the following line that works fine when the query isnt linked to the front page Set rs = CurrentDb.OpenRecordset("UkMailDataNotDelivered") but now i need it to use 6 details from the home form. I think the 2 options are to load the query with the 6 variables or add them...

cheeers gemma, s should it be Do While IE.busy = True And Now() < cTime Or IE.ReadyState <> 4 And Now() < cTime i basically want it to exit the loop when either condition is met, so if now is greater then ctime, or either ie is completed

I did the watch thing, they all show the values that normally get it out of the loop, its bizarre Processed 2000 records first time and few hundred on second attempt

ive looked at the bits in the while condition and they all show values which should escape it,

just put in ie.visible, and it shows the ie window, fully loaded as per msg box`s, but yet doesn't come out of the loop its as if its forgotten the do while, but you can still use other buttons on the form and use, so access etc hasn't crashed

It basically, goes to web page enters a consignment number, then returns the recipients name and date signed for package. It all works had it do 3000 consignments in one go, then other times a few hundred. There is loops/catch errors so if theres a fail it shows the error message etc but it...

Right, this has kind of got me baffled. I run my code and it loops fine most of time, it can process upto a few thousand records then gets stuck here, no fail messages cTime = Now() + TimeValue("00:00:5") Do While ie.Busy = True Or ie.ReadyState <> 4 Or Now() > cTime ' MsgBox (Now() > cTime)...

ok ive kinda found the issue, I also change the name of subject With olMail .Move objDestFolder .Subject = "SS- Customer: " & Prefcus & " - " & Prefpd & " - Surveyed By: " & Prefby .Save End With if the moves before it moves all emails, but wont change subject, if subject change is first it...

Hi Paul, Here is the actual test code, the other was just a partial bit of a much larger one. It works on first email but none after that, but with the msgbox works everytime. Its run thought a run script on the mail rules Sub RunMove(MyMail As Outlook.MailItem) MsgBox ("start") Dim strID As...

Right I have the code in place but it will only work first time out look is opened, unless I have a msgbox on the first line and, I cant work out how to make it work with out it, obviously the msgbox isn't code doing any thing but it must be setting focus or some thing, here is the code, any...

rarther then " " as this will search for a blank space try "*" as this will bring every thing or "RECEIPT" & "REJECT"

Right my query is working fine and creating a report this is how it works, User clicks button , it runs the query report and prints it, it then updates the records so it doesnt print these again. here the script is On Error GoTo Err_Command45_Click Dim stDocName As String stDocName...

right if i have that on a cammand button to open a form on set data it works stLinkCriteria = "[Visit ID]=" & Me![List43] how couldi use this to show the form in the same form , so it looks at the list box then shows it next to the listbox

really alls it needs to do is look at the listbox at visit id and look it up in the table and display it in a text box , and to refresh when the list box changes thanks still_rookie

noop , i really need a solution to this its the only part that im really stuck on could u try downloading the db file and having a look for me pls

no sorry i think its because the notes are in a different table i have 2 tables Customers [Customer ID] [Customer Name] Visits [Customer ID] [Visit ID] [Date Visit] [Time Visit] [Duration] [Notes] the realations are Customers [Customer ID] 1 to many Visits [Customer ID]

right date visit , time visit listbox , duration listbox, visit id listbox are all in a table. same details as the sub form a requery is done when Customer ID changes , but some times the date visit list box doesnt update proporly. All the dta in them list box`s should show the same as whats in...

its me carnt spell to save me life

Right im really stuck on this, how do you get the date visit to update correctly, it requeries but some times shows data it shouldnt. it should corispond with the subform. next thing is the text box that says 'name needs to display the notes from that visit in , ( that thats in the sub form...

ok is there a way of looking in a table for a ID number then to bring up the correct record from a memo field to a text box.