Search results

Well after looking at the database every table has all the same field names correct? Makes it a lot simpler If you go into the OnClick event of the buttons on the form i worked on, you'll find all the code which is used. Copy it all, and paste it into the OnClick event of the button you're...

No problem. Any time. Hope all goes well :) Adrian

Heya. I've got it working to what I think you were after. Ok. When you click the transfer button, it checks to see if you've actually selected a record from the list box. If you haven't, it'll pop up a message box, stating that no record was chosen. If one was selected it will continue. A...

When you say if you make a mistake and want to reverse it, does that mean that when you move it back you want it to delete the record? Or are you just wanting to clone the record each time you copy it from one table to another? so just copying when transferring between both tables? Or copying...

Here ya go. I've put a new combo box at the top of the form. just click it and it'll list all the records you have, then it'll load that record. Just as a hint for the database though, I'd look into doing a relational database, or at least normalising it to save on problems further down the...

How do I check if another computer is on? Basically the back end is going to be stored on a computer (no server involved. Small P2P network) and it obviously needs to be on for everyone to access it. Is there a way of checking if that computer is on first before doing anything else? I can...

Ah wow. I swear when I did that first it just deleted the image box with it :( Thanks :)

ah right ok. Tell you what, send me a copy of you db and i'll see if I can get it running for you if you like?

Ok. Is your form based on that table? You say colums?? Is it a list box, or do you just mean fields?

Ok another couple of questions. Is the list box on the right, the LV one supposed to list the records in the LV table or just values you specify? Also do you want to be able to copy them in reverse? IE. from LV to DL? And do you want there to be a warning? Or request for user input?

Thanks. Works a treat No Idea why there are Colons. Not my DB. Helping someone out and they've put them in. But i've got it working now with them so all is well. Thanks

StrSQL = "INSERT INTO LV (Directory_Name:,Filename:, Total_Files,Total_Records:,Total_Batches:, Total_YH) VALUES ('" & DirectoryName & "', '" & FileName & "', TotalFiles , TotalRecords , TotalBatches , TotalYH);" Have tried loads of combinations of the " ' and ' " to get it working but just...

hmm weird, should be the first thing to come up. Ok then, put this in the AfterUpdate event of the combo box but you'll have to modify it ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[Room Number] = " &...

Cool thanks, got it I think

How do I pull a value from a certain column of a list box? I want to retrieve the ID number from the ID column of a list box, but have no idea how. Please help. Thanks

oh yea, do you want it to transfer all the records, or just the record that is being looked at at the time?

there ya go got it that time

There is no attatched file???? Get it on, i'll take a look at some point. Gotta go to a friends house now and sort out some problems then i'll take a look this evening.

ah perfect! Works a treat. Thanks very much. Never been that great with error handlers. Thanks again

Yea course you can. Give me all the details of what table you want the record copying and to where. Do you want it just copied? Or deleted as well?