Search results for query: *

Hmmm - That is strange. Can you try debugging again, and this time paste all of the output? It looks like you only pasted the bottom portion. And also - I copied directly what you pasted into this post and ran it with the debugger, and it worked - maybe you try doing the same? Maybe there is...

Thank you for your replies! I am looking into both of them. Thanks Again, Brian

You set the No_Buttons_Selected to false at the beginning of your function. What happens if they check the first button only? Then when the code checks radio button 2 & 3 (which are NOT checked), it will set No_Buttons_Selected to True. Instead only use 1 if statement, but use AND to check if...

I could be wrong, but I think one of the problems could be your last argument of the DLookup function. Instead of "Row=Forms!FormsA!Number" Try: "Forms!FormsA!Number=Row" Forms!Forma!ReturnedField = dlookup ("Forms!FormA![Field Name]", "Table Name&quot...

I have a database that has been upgraded/updated over the years. I know there are some tables, queries, reports, etc. that are not linked to anything. Is there a way to see if a certain table is being used by any other object in the database before I delete it? I can always make a backup of...

Hello, I have a database and I have one table that holds all historical data on test scores(named [SubSheet PN Test Scores]), and one table that holds the current year's test scores(named [Table NCLEX Quarterly Totals]). The contents of [Table NCLEX Quarterly Totals] are updated manually...

I have a problem with using my Access2000 database in a mailmerge with MS Word. I have secured my database so users cannot tamper with the design: the database window is not shown on startup, and on startup a login form is displayed (popup & modal) so the user must log in. The database has...

Thank you very much for your suggestions - I will try them both! I still don't know if I will be able to use shortcuts, but I will definitely try that one! Thanks again! Brian

I have a question about how MS Access 2000 uses memory. I am running a database with about 150 records. My main form has a LOT of controls on it - and about 3 or 4 subforms too. I am expecting the form to take a little while to load with that many controls. But I noticed something about it...

Thank you everyone! The Subreport did the trick! I still have to fool around a little bit with the format of the report now, but as far as getting everything included in the report I am sitting good. Thanks again! Brian

Okay - what is your email address? Do you want a screenshot of the report?

Well, I changed it to "Each Value", and it still doesn't work. The information for the report is coming from 2 different tables - does that matter? There is only one record in the main table, but many records in the additional numbers table that are linked to a single record in the...

Hi, I have a database of organizations, and I want to create a report to show the organization and its mailing info and telephone numbers. The source of the report is a table that contains all of the information on each organization. However - I have another table linked to my main table...

Ahhh- I didn't see that "Same as detail" checkbox. Thank you very much! It works perfectly!

Thanks Jim, But when I try to make my Page Header wider, it makes my Details section wider also, so that even if I specify in Page Setup that I want 2 columns, it will still only let me have one column, because the width of the detail section is to big... Am I doing something wrong?

Hi, I am trying to make a report that has is two columns. It is a list of names and addresses, so it is pointless to waste space only using one column - it is so much more efficient to use two columns. Now - I know how to set up two columns (I think). I went to Page Setup and went to the...

Thank you very much Robert - this looks great - I am going to try it out right now!

Thank you so much Robert - Like I said, I've struggled with this one for a while and I am stumped. Any extra tips or help would be awesome! Thank you very much! Brian

I am brand new, so I am not to sure what you mean by table structures, so I will give you this, and if you need different, please let me know.... --------------Tables------------ Table People_List ID First Name Last Name Address City State Zip Code Table Other_Last_Names ID (Exact same ID as in...

Hi, I have been working through this problem for a while and I have been looking through these forums for an answer and couldn't find one, so I thought I would post it: I have a database with a list of people in it. In the main form, I have a subform for previous names (A woman who gets...