Search results

I ended up putting a textbox on the form and holding the value there. Ultimately it seems to be the most straightforward way to do it. At some point I would like to understand the intricacies of private, public, temporary etc. variables but for not the quick and dirty invisible text box did...

MajP Thank You. I had found some of this on line and was tinkering with it. hadn't gotten the syntax just right yet and I was trying to pass a string ">" & BegDate. But it looks like I just pass a date. I can try that but I noticed you stated that you would not do it that way. I am...

If there are exactly three different kinds of import tables you could write a process to import each one. Could the user then be asked to select which type? If so then easy peasy. If not then you could have your database 'test' the import table to see which it is. Such as If column 5 = Zebra...

I have some code which sets begin date (BegDate) and end date (EndDate). I have a query (qryOutput) which filters properly however I don't filter on the field create_date (yet?). I want to use BegDate and EndDate as the condition to filter create_date. Later there is a command to export the...

Thank You, that did it. one of the fields has an 'after update' that doesn't fire when the data is put directly into the table instead of entered through the form. I'll have to figure out how to do that because that kicks off a procedure that assigns a tracking number. but i'ts almost 4...

dbs.Execute " INSERT INTO tblDocsIssued " _ & "(DocType,PartNum,AssignedVendor,ProjNum,SQEName) VALUES " _ & "('PRR',me.item,'BestVendor','5555','Gary Kissick');", dbFailOnError MsgBox dbs.RecordsAffected & " records inserted" 'example of ways to insert data from the form...

OK. Marginal progress. I got it to work using the 'dummy' data. dbs.Execute " INSERT INTO tblDocsIssued " _ & "(DocType,PartNum,AssignedVendor,ProjNum,SQEName) VALUES " _ & "('PRR','U5JJJJ','BestVendor','5555','Gary Kissick');", dbFailOnError I have tried...

Yes, so it looks like I need to assign something (or null) for each field. so the real value comes from being able to assign those based on controls on the form my button was on. At this point I am hoping I can use Me.DueDate with DueDate being the name of a textbox on the form. I'll try and see

Runtime 3314 .. you must enter a value in the 'tblDocsIssued.DocType' field. … Looks like it doesn't understand that tblDocsIssued is the name of the table that I want to add the record to.

Tried to add code to make a new record with a few pieces of 'dummy data'. It ran but then I opened the table that was supposed to have the new record and I didn't see anything new. Good news.. No errors though!! Am I missing something? I found the code in MS development, looked pretty...

I will try it. Am I making a safe assumption that it is better to do this in the back end database rather than call the linked table that is in the front end ?

I wanted to pass a few values then have the user fill in the rest of the form and this is always a new form. So its not just a matter of adding / changing data in the table. Although I did have the thought to first create a new entry into the table in the target db with the 'few values' then...

I found some code to open another database off of a button. I have gotten to a point that I can open a form within the target database and open it in 'new record' status. Next I would like to pass some data between the two databases and am looking for some help with that. Any help is...

I have developed an MS Access database (with no small thanks to those in in this forum who helped me with various challenges) that has grown to a point that there are a half dozen users. Particularly after going through some turnover in the department and for other potential forsee-able issues...

Yes, that did it. Thank You

Trying to update a record in a table based on a click. I done something similar in another db so I copied the code then changed in the right fields expecting all to work like clockwork. does is EVER go like that? I am getting a type mismatch error but I can't understand what I am doing...

Yes, zero column is the 'index', that is what I get with Me.DocStep As I understand this is exactly what you should get with Me.DocStep since the default property is .value and the zero column is what should be returned for .value. DOH! I was using the field name DocStep when I should have...

EmailSubject = " Notification: " & Me.NewLBTrackNo & " Status: " & Me.DocStep & " Due: " & Me.DueDate I am using a button to send and email. All is working well except one detail I can't figure out. In the above you can see … Me.DocStep & …. Right now that give a number which is the 'ID...

Yes, It worked on the MRR DLog output db. Thank You Sir.