Search results

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...

I successfully used sourceobject to load only the relevant form--the trick is to have a default form loaded in the unbound subform when you open the main form, otherwise it crashes. Private Sub cboTools1_AfterUpdate() If Me.Tools1.Value = 1 Then Me.sfmTool.SourceObject = "sfrmA24DJE" ElseIf...

On current I think just refreshes when the form is loaded. I put a default form for the oncurrent and the code to select the proper subform is on the afterupdate of the relevant combo box. In any case, the on current default form is loaded except at the very beginning.

Alright I gave the SourceObject approach another try, this time setting a default SourceObject on the form's 'on current'. I think that the issue was I didn't have a default form linked to the subform.

Access would close down or I would go to form view and the form would close. When I tried to open it, nothing would happen--the computer would try to open it and ultimately would fail to do so. I would then have to rebuild the form from a saved version, and eventually the same thing would happen.

I was doing that to an unbound subform, and it kept corrupting, even though it would often work a few times. Are there others that don't involve an unbound subform or loading all the subforms onto the main form at once?