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

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

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

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

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

hi ive got a query that works for all my list boxs , but how do i get a text box to show whats in a memo field within the query

i have a query that returns the values in list box`s but i have one colum in the query that is a memo , and i need this to be displayed in a text box so others can edit it. how do i go about doing this as there is no row select option on text boxs

which event should i be using that will run the procedure when the data is changed regardless if that text box is highlited

how can i create a query that uses a customer id text box rarther then having it a pop up box asking for the customer id ive tried using [Forms]![Customers Details]![CustomerID] as the criteria but is still asks for it cheers

ok im pritty new to this but the problem i have is i cannot get the list box`s to update like the subforms do what i really need is when u select a customer the date box at he bottom left updates like the sub form changes and the time n duration to just show the one just 1 time/duration for the...