Search results

Not sure exactly what you mean by opening the mdb without running access. Are you trying to run multiple users at once? That's usually when you'll run into ldb issue. Read up on splitting the dbase front end and back end. Each user has their own mde file with linked tables for a common backend...

I can get this example from Allen Browne to apply to my database ok, however I'm stuck on getting 3 sets of values. In the example below I get qty and amt. In my example I'm trying to get qty, amt and budget. I added budget to the tblxtabcolumns and I can get it to pull up as a column however...

Hey all, Working in someone else's Access 2003 database. Based on my limited knowledge of VBA and access I expected to find a table called "CFI11 for CFIMaster_form" (read code below). However no such table exists. Can someone point me in the proper direction? The SQL is the same as...

Hi all, New VBA user, Access 2003, Win 7/XP The code I set up below fits my need but I can imagine is grossly inefficient if it were to be a much larger scale set of VBA instructions. How would the experts approach this? I also thought of using a select case statement. For what I'm doing the...

Just shooting in the dark, maybe try a different browser?

Thanks all! I'm pretty sure most of the database examples I have been teaching myself with are turn of the century-ish creation dates, so that explains some of the issue. I'll give it a go at work tomorrow and report back.

It is a list box on a Single form.

Private Sub DeleteRecord_Click() On Error GoTo Err_DeleteRecord_Click Dim msgboxanswer As Integer msgboxanswer = MsgBox("Are you sure you want to Delete this Record?", vbOKCancel) If msgboxanswer = 1 Then DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem...

Can PM me details? Thanks spike!

always interested in looking at something new. Can they do a demo? Value for the $$ always a big concern in the industry :) Thanks for the heads up.

Hey all, Working though one of my first attempts at making something happen with VBA, Access 2003. It's going pretty good so far but I've run into a small snag. I've got sample code for dynamically setting the filter property of a form using several unbound combos found online and adapted for...

Use of sub report tool will allow you to get info from different queries onto one report

How'd you do it?

Just thought perhaps I can do the recordset portion of this problem entirely by query. Thoughts?

Hey all, Using access 2003, getting more familiar with access, new to vba. I'm working on setting up a user notices system that will log receipt of a notice when the user inputs their password. Setup so far Table users Userid Username Password Table notices NoticeID NoticeBody Table...

J Razz Seems like you've been making some really good progress! Now that you have a table Cases and a field in that table CaseID (PK) that is in many other tables as a CaseID (FK) you shouldn't use it for another application such as manually typing in a previously assigned CaseID from another...

If you view one particualar table in design view you can change datatypes. Primary keys will be autonumber and foreign keys number. Change ID field to number first, then set your ClientID to autonumber. Take a few minutes to go back to that link back in my first post. If you can't take the...

Please do let me know if I am on the right track! Yep. I believe that a "request" is related directly to a case and not a client, correct? You should adjust your relationships if so. Delete the one from clients to requests and form a new one between requests and cases. You can remove the...

So, in my situation, I would want the Client ID and the First and Last Names to be in two different tables so that they would not have to retype at least one of those (id or first and last name) when they pull it up from a search. close, we're back to the Primary/foreign key concept.When...

Can you further describe the filtering process? Use of VBA? what exactly triggers the error? Same computer or different computer?