Search results

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?

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

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

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

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?

So far, in scrounging forums and looking at databases, I've noticed two ways of doing it, neither of which works very well. A) Using SourceObject to define a pre-existing form as a source for an unbound subform --Works when it works, except it keeps corrupting and locking out B) Hosting all...

I set up a form with a subform selected by a combobox. It wasn't working so I made a textbox to display what the combobox was returning. Access seemed to glitch a little, so I closed it, and now I cant open the form (regular or in design view)--How do I get to my form? Do I need to load an...

I just expanded my database to include multiple departments. Originally, it only contained one--to navigate between different depts, I created new switchboards. However, they all have the same title as the original department's switchboard and I can't access the new switchboards in forms to...

Every time a tool is used, I would like the runcount of that tool to be increased by one. The tools are in a table "Tools", connecting to table "JobEntry" by field ToolID. My code for the job Entry command button: Dim runcount Set runcount = db.OpenRecordset("Tools") runcount.Edit...

I'm having trouble changing the .MDB file's icon in XP. Now I've searched all sorts of forums and read every answer, and inevitable I hear to go to startup from database utilities, but that changes the window's icon. I am trying to change the database from Access's purple key thing to the...

The people who are entering data into the database shouldn't have the ability to edit the database--only to add new records. How do I take away that navigation bar at the bottom of forms and automatically present a new form everytime the form is opened? Thanks in advance!

I see the Switchboard items in tables, but I cannot find the switchboard in forms--I can't even preview my switchboard or run it at startup! I've created a switchboard, how do I fix this?

I'm designing my database to keep a queue of lots run--However, I am afraid that using my "Job Entry" Form (there's also a job working, for when the lot is run, and Job Completed Form, for after the job has finished), those logging the jobs will accidently edit previous lotnumbers, etcetera. On...

Designing a database able to hold a lot of simultaneous lots that needs at least two edits after creation--Time Worked and Time Completed. However, I am having trouble. I need to: 1) Lift the Lot Number off of the combo box 2) Search for the Lot Number in the Job Entry Table (it could be...