Search results

yes, I know, but I have fields on my form that aren't present in my sourcetable(the one linked to the form). Should I than make new fields in the sourcetable for every field on the the form? Or what should I do with it. If so than what would you do with the calculated fields?

thx for the reply but, I still don't get how I can put field-values into a new table. This code appears to be working with two tables, and not with a form. Let me give you an example: I have my form set on continuous forms. It's linked to a table and has has an equal amount of (form)records...

I have a subform in another form (the main form). The subform exists out of continuous forms representing records of a table, (table1). The form (so one of the continuous forms) contains some fields, but not all of them are from the table (which is the recordsource for the subform), some are...

I have a main form that exists out of two subforms. Whenever I click a button, I want all my records in the lower form to be inserted(added) to a table. The upper form uses that table as part of a query. So after the button is pressed, I need to update the upper form so it also shows the new...

Lol, I just thought about something. If I use a adodb.command to do something in the likes of: "SELECT CustID FROM Customers WHERE CustID = '" & mystring & "';" it should return how many records where affected right. So if it's one than its found, if it's zero than it should be created. Or...

So here is the problem, well, not actually a problem but rather a question to see if there isn't a better way to do this. I have a textfile which contains lines of information. I read them line by line and than need to check wether or not they are already in the database. Therefor I need to...