Search results

Ah yea sorry, the Question declaration was me experimenting with looping and seeing the entire msgbox to that variable, then trying to call it and use it as the get out for the loop but it didn't work :( Isn't that example still using the GoTo function though? As it is still there?

Well yea i thought so to, and tried to use a Loop to do it, however I couldn't figure out how to jump out of the loop, as it was dependent on the results of a message box. Here is the full code: Private Sub Form_Load() Dim BackendLocation As String BackendLocation = DLookup("[Database]"...

Alright cool, thanks :)

Ok little problem with the code after that. I want it now to update the MSysObjects table with the new location selected by the file browser, and the following doesn't work: DoCmd.RunSQL "UPDATE MSysObjects " & _ "SET Database = BackendLocation " & _ "WHERE Database =...

Ahh thanks so much! Working perfectly. Always something small in coding :)

Ok i'm getting slightly confused now sorry. So setting the TimerInterval, is that just a normal variable? or the system timer? I assume the countdown integer is also a variable? When you say public, do you mean just declare as public, within the form, or in a separate module? Then i just get...

If strInputFileName = "" Then If MsgBox("You Must Select A Backend. Without It, The System Cannot Run. Are You Sure?", vbYesNo, "Are You Sure?") = vbNo Then GoTo Line1 Else MsgBox "The Database Will Now Close.", vbCritical, "Warning" DoCmd.CloseDatabase End If End If The code half...

Oh right ok, yea that would probably be perfect. How would you go about doing that. I know how to put code into the Timer even and set the timers interval to whatever time i need but how do i get the code to run the timer interval and reset it without it constantly running the timer all the time?

I've got custom buttons on the form to skip the records. With the timer, do you mean to load the picture after a certain amount of time? so that the rest of the record loads quickly, and THEN it loads the picture after the timer?

Nah i don't want it to be sluggish, just prevent it from freezing. It's if the user skips just one record, but it's when the press the skip button a couple of times, and it's basically just the image that is causing it to freeze. I could put the picture on a separate popup form but i'd rather...

Well basically the form has a picture of the member of staff of each record which is working fine, however when the user skips to the next record and then skips again and again quite quickly, it slows the whole thing down as it tries to load the next picture each time, and it causes access to...

Brilliant. Thanks for the response i'm sure i'll be able to figure out something from the link. Appreciate it :)

Is there a way of locking the form of any use until the record has completely loaded? Thanks

Hiya. It doesn't have to be done with a macro, it can be done in VB but if you want to do it in a macro then do this: Create a new macro In the action column create the following 3 actions: OpenForm GoToControl SearchForRecord Change the properties for each one to the values you...

You may be able to do it in asp.net as it is just a form of vb.net coding behind the web interface. You'll probably have to re-do the form but you can still do it in VB. If you go to msdn and download the visual web developer express for free you can experiment. It's an easy to use program and...

How did you set-up the search for both the main form and the subform together in the first place? Could you not just add the new field to this search?

1. You've already done (title) 2. For a drop-down box, open the toolbox in the forms design view, and create a combo box. Go through the combo box wizard, and tell it to lookup values from a table. Select the fields you want it to show and finish the wizard. In the properties of the combo box...

Thing is, I don't want it to ask for a new back end location every time the database is run, only when it can't find the one that is set at current. Also I want that UNC to be on the file browser for the picture?

Yea. I had a look into it the once but it just confused the hell out of me as how to actually implement it? :confused:

Well that is how i want it to return the location of the picture, so that the pictures don't all have to be stored in the same place. I'd rather they were a network address like //server/Documents ... but i just couldn't figure out how to make the file browser return that rather than the local...