Search results

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 just used SourceObject to load forms into the unbound subform--I'm going to change tactics though. It worked, except for the crashing and lockouts haha. ** I have about 12 forms that potentially load into the empty subform, selected by a combobox on the main form. I'm looking up other ways to...

Access is having a lot of trouble with the unbound subform. I am now contemplating switching over to VB altogether--but it would take quite a bit of time. Bad idea? Is it my error or Access having issues?

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

My issue is best described as this. I have a switchboard with an accompanying form, which works very well. However, when I try to make a new switchboard, it does not create a new form. Therefore the format of that switchboard is exactly the same, and I want the switchboards to have different...

only the original switchboard appears in 'Forms'...there are no forms for the other departments, or the now-default "umbrella" switchboard

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

Finally got it. Took your advice, scooter, took a deep breath then wrote out what I needed to do. 1. Find the toolID from JobEntry 2. Open record of ToolID in Tools 3. Go to RunCount field, add 1 This is what works: Dim objtoolID As Object Dim obruncount As Object Set objtoolID =...

Sorry, I was getting flustered yesterday. LotNumber is a text field--that is easily corrected on the code. I've disambiguated the objects from their fields--now looking up dlookup and string usage. Sorry I was so back and forth--I think I need to learn the fundamentals of dlookup and recordset

How do I do that? I'll put it up if I have to, but maybe this conveys what I'm trying to do (db already defined CurrentDb): Dim toolid Dim runcount Set toolid = db.OpenRecordset("SELECT [ToolID] FROM JobEntry WHERE LotNumber = '" & Me.LotNumber & "'") Set runcount = db.OpenRecordset("...

Ok, I'm slowing down. The 1 parameter is to a different issue i can handle. There is no space in ToolID or Runcount. code is now Set runcount = db.OpenRecordset("SELECT [RunCount] from Tools WHERE ToolID = " & Me.cboToolSelect) runcount.Edit runcount("Runcount").Value = runcount("Runcount") +...

This just in. I changed the name to ToolID in tools (before it was tool, i figured I would make them the same for ease's sake), and now its 'too few parameters. expected 1'

Thanks. Tool ID field is a long integer in table JobEntry and in table Tools RunCount is only in table Tools and is a long integer.

Tried that, got 'too few parameters, expected 2'. I ran into this earlier, but I'll admit I have no experience in parameterized queries (I use the SQL query builder whenever possible). I don't know what =" means either...yikes? In any case, it requires another parameter... If this is demanding...

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

The only issue with the shortcut is that this database is hosted on a server and accessed by hundreds of computers...that many individual shortcut icon changes is a huge hassle. Buuuuut, I was just trying to change the extension and my access is blocked. Working on it.

I'm trying to just change the icon to the one database (not all *.mdb files)--I do realize this is a Windows issue rather than an Access one. I think I'll have to resort to VB to change it, but I don't know really how I run code outside of access. On older versions of Windows, it was just a...

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

Worked perfectly. Thanks!

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!