Search results

Found the problem, but it still doesn't filter properly. The issue seems to be the that I open the Testing form with the Main form, but when that happens the Testing form isn't passing the criteria to the query...so I guess I have to figure out a way to pass the criteria twice. Does that sound...

That didn't quite work. Clicking the button on the Main form opened up a criteria dialog box, which I don't want...I want the criteria to be passed directly. Also, even when I did enter the criteria I was looking for, it didn't get passed to the testing form, so all categories were still...

Question: I have two forms: Main and Testing. The Main form functions as a main menu and I'm creating command buttons to open other forms. I want the first button to open the Testing form and apply a filter at the same time. The testing form pulls it's data from the testing query. I would...

If your query is pulling data from tables with empty fields, you may need to change the join type.

Hi all, I'd like to open a report based upon a selected criteria. The report is based on a query, and within that query are records that fall into 3 different categories. I'd like to set it up so that when someone opens the report they can open it showing only the category they're interested...

I used rainman89's suggestion and it fixed the problem. Can either of you tell me what I just did in theory so I can better understand and stop asking so many damn questions? Thanks!

I'm not sure why this happens, but: I have a query pulling data from two tables: tbl_audit and tbl_exceptions I created a named tbl_status with the fields statusID and status, added a statusID field to tbl_exceptions and created a relationship between the two. I then added tbl_status to the...

Thanks much! I'll give it a shot and see what happens...after I back everything up, of course. :D

Yes, unfortunately that's exactly what I mean. :(

Question, I used lookup tables (using the lookup table wizard) when I designed my DB. Now that I've split the DB it's caused some serious slowness when forms are first open and all of the tables start looking elsewhere to pull data. Is it possible to break the relationships created by the...

Worked! Thanks much!

I have not tried that. I'll give it a shot and let you know how it works. Thanks.

If I open the backend directly I get a "The database [name] is read only. You won't be able to save changes made to data or object definitions in this database" If I try to access the table from the front end it doesn't give me any messages, just won't let me add a record no matter how I try...

Hey all, I split my DB and now cannot add any new data directly into the tables. Am I doing/did I do something wrong when I split the DB? How can I add new data to the tables? Ugh....

Hummm...isn't that just super. Tried repair and compact...no dice. Guess I'll have to recreate...oh the joy...

Hello all, I have a report that is opened by a button on a form. The data in the report is determined by a variable that is passed from the form to the report. When opening the report without the DB being split there is no problem, but after splitting the database it gives an error, but only...

The likelihood of more than 99 numbers of the suffix is is extremely low. Also, while you have split out the primary key into an alpha and a numeric, I won't be able to do that. I'll try to figure out how to adjust the example you gave me without destroying it too badly. :)

Fortunately the number of users will be minimal so there shouldn't be much of a concurrent user issue. I'm not a code guy by any means...do you ahve an exampled of the dmax() plus one you mentioned?

Here's a good one for you access gurus: I have a primary key field that consists of values such as ENT01, ENT02, COMP01, COMP02, etc. The user will need to increment the value to the next value in the sequence when they create a new record and I would like some way for them to be able to see...

Works like a champ. Thanks a ton!