Recent content by Theguyinthehat

Having all the users in my company download Access is a nightmare of red tape--everyone can run .NET

I'm converting my access db to .NET and its a disaster, there's so much DAO terms. I cannot find out how to change the following: DoCmd.OpenForm("blah") into .NET. Any help?

Wait, I figured it out. The record hadn't been created yet--Nothing is saved to the table until the bulk of the code runs. My bad haha.

I tried multiple names for the object, and made explicit the DAO (though its higher on the references)--neither worked. The problem begins at time.edit (now t.edit)-- It seems to access the records perfectly.

I really don't get why it can't find the record. I've checked spellings and everything. LotNumber is a text-formatted field, so that's right. Can anyone spot the problem? In the past I've used invisible text boxes to host the time, and I could do it again, but I'm sick of skirting bugs I don't...

Sorry--let me better explain. The very first form has 6 potential entries (that's as many slides as the DPT machine can handle at once). When they indicate fewer slides, say 4, there are 2 records without CZT numbers. I then know to delete these. Since I'm running my for loops assuming 6 records...

great! Thanks. One more thing--I had to move the strSQL expression behind the puck and cthick edits (and made some other changes that became obvious once I ran the code). How do I prevent the code from making edits on entries that don't exist? Oftentimes I only have 4 entries, therefore sub lot...

I use a strict convention in naming--the boxes indicating thickness are 'thicktxt#' and for the mounting puck they are 'txtpuck#'. In any case, I currently have the form set up to accommodate 6 of each. However, if I change this to 7, is there some way I can set up the code so I only have to...

Sorry! Figured it out--had to specify DAO. Thanks!

There are 5 subgroups assigned to a single LotNumber on a form I'm building. I decided to use a for loop to create a new record if the corresponding textbox was filled out, but on the openrecordset I get a type mismatch error. Some help? Private Sub cmdSave_Click() Dim db As Object Dim...

So far I have managed to tiptoe around opening a record, but the time has come that I can't keep making references to invisible columns in a combobox selection. If I have a table JobEntry, and I want to look up a specific Lot Number with cboLotNumber, how do I open that record using...

Thanks--You always have the answer.

I still can't compile with the line dim rst as DAO.Recordset and I've looked everywhere for a way to 'enable' DAO without any luck. Can anyone help me out?

I figured out how to do it, for those interested. (Just for the Target Current field value in JobEntry entered in a textbox txtcurrent on the subform acting as a SourceObject for the unbound subform sfmTool, editing a record specified by a combobox LotNumber on the Main form...wow that was a...

Well you nailed what I'm trying to do. All my forms are set for data entry (and without navigation buttons). The main form creates the records, and I want to use the subform to add more data to the same record. I would use the same form but there are different fields that need to have values...