Search results

at the very beginning of the code before anything else I have this On Error GoTo Err: Then at the end after everything I've got this Err: MsgBox "There was a problem opening the Report" & vbNewLine & "Please try again", vbInformation, "There was a problem" Exit Sub

ah ok. Well assuming the two tables have got the same fields then just create an append query to copy the data from the one table to another, then a delete query to remove that record if you need to. Then make the query run when you click the button

Sure. Ok in design view of the form, go to the toolbox, and find the combo box option. Then add one to your form either by just clicking or clicking and dragging to specify the size. Once you've done that, a window will pop up which is the combo box wizard. In this window, you should then have...

I've got an error handler to obviously check for and error, however it is saying there's an error when there isn't one. I've got one very large IF statement running with others in it. Outside the if statement is the error command to go to the function of what to do on an error, which is outside...

Ah ok that should be ok. If you create a new combo box somewhere on the form and let it bring up the wizard, you should have 3 options, one of which (should be the bottom one) is what you're after. It'll load the record that you select from the combo box

probably with a bit of VB. It depends what you mean by fill the fields. Do you want it to lookup information already stored and just show that record? Or do you want it to fill in new data for that record? If the latter, then it'll be in VB. You'll need to specify what values you want for each...

Declare a Global Variable, which takes the username when the user logs in, then when you open the form, or at whatever event you want it to happen, run an UPDATE SQL string to add the name the field in the table, or if the form is based on the table you want the name stored in, then just add the...

If they're just List boxes then transferring the contents of one to the other shouldn't be that hard. Try something like this Dim i as Integer i = 0 Do until i = list.ListCount List2.AddItem (List.ItemData(i)) i = i + 1 Loop List and List2 you need to replace with the names of your two...

Fantastic, thanks so much. Just what I needed :)

Brilliant thanks. Found it. Don't suppose you know how to return its current position so I know where to be moving it do you?

How do you control the position of a form programmatically?

For records that have an image (such as members of staff having a picture for each one) what is the best method for displaying this picture on the form? Currently I've got an image box which is updated with the file location reference stored in the table. it work well, however, in order for the...

Hey, thanks again. Got one up and running now. Had the same problem as before but just told it to close the form before deleting the record and it works a treat. :) I'll leave you the credit thing on here later as it wont let me right now. Says I need to spread it around first :)

Ok no worries got it sorted, thanks :)

Surely I would get to that value if I'm adding 0.001 each time? It would have to get there wouldn't it?

Can anyone see why this code is causing access to hang EVERY time I TRY and run it. It doesn't even run at all, just hangs outright. i = -1000 Do Until i = 1000 Do Until Bar.Left = 5.529 Bar.Left = Bar.Left + 0.001 Loop Do Until Bar.Width = 0 Bar.Width = Bar.Width - 0.001 Loop...

ah brilliant, thanks so much! I'll take a look through it all later. Mouse battery is dying, and it's about 2:20am here so might head to bed soon. Thanks for all your help, i'll reply if i've got more db problems, but thanks again so much. Appreciate it :)

How Do i build it into the form? I know there is the status bar one but i want to try and avoid that as i want it to be as visible and obvious as possible to the users

Damnit! That works :( Now how do I go about using the progress form without it stopping it from working? I mean obvious the Delete function is much more important but would be nice to have the progress meter?

haha yea sorry should've explained a bit more thoroughly. All the queries move the data in the linked tables, then delete the data in the linked tables ready to have the main record deleted. Unfortunately, if I try to delete the member of staff first, it just stops it due to there being related...