Search results

I did find something out though, whenever I changed the primary key from number to text it did show the report then. However when I changed it back to a number format it still gives me the error messages that I have listed previously. Thank you everyone for your help. I may have to see if...

I agree that buttons on a report are not that great of an idea, however not my choice. The people who make a heck of a lot more money around here than I do want it done. I don't want to print it out just review it on a report is all. Still have anything to do with the margins?

I've tried both variations of it and still no progress. Currently here is what I have behind the button DoCmd.OpenReport "Report1", acViewPreview, , "Citation = '" & Me.Citation & "'" And it spits back the error on the picture attached to this reply. :banghead::banghead::banghead:

Hello all, I'm having a little trouble getting this accomplished. I can instruct access to print the report, however I just want to be able to view the report after I select a button. I will attach a picture so you can see what I have thus far. I do have an older version of this and it works...

Bob, on the left hand side whenever you have access open it shows all related table/queries etc. within your db. Whenever I delete my table and then import the newest table it shows up down at the bottom under the tab "unrelated objects". Not really sure how to get it setup again. I have to...

Burrina and bob, thank yo for your replies, Burrina I have tried that approach, however it places the table down in "unrelated objects" so when I try to run my queries and reports it is unable to being it is not "grouped" with the reports and such, Bob, I have tried your approach as well a...

Hello all, I've been having this problem and I can't seem to get any help on it. I've tried posting in the table and query forum, however I think it might be beyond that. Here is what I have: DBA (older DB) DBB (newer DB) I am wanting to take all the records in DBA tbl...

Nope nothing yet, still fighting it.

Bob, Thank you for your reply, I have tried to import the table, however when I do that it puts the table down into the "unrelated objects" category, whenever that happens I can't run any of my queries or reports. As for linking them, that isn't an option either being that the guy who wanted me...

Hi everyone, Here is my problem that I am having: I have 2 db, DB A (older db) DB B (new db) What I have done is updated some functionality of the DB A, what I want to do is have a query that will take all the information in the table of DB B (new db) and put it all into DB A (older db)...

sumox, Thank you for your reply, however your approach would take me a very long time as I have approximately 1800 records total. I just never thought that copying, merging or appending; whatever way you want to slice it would be so complicated to complete. I can import the data into the new...

Cronk, I've tried to delete the old table from the updated db and then import the updated table into the updated db, however when I do that it says that I have to delete the relationship between the 2 different tables. After I do that then bring over the new table, setup the relationships and...

Beelte, Thank you for your reply. I am indeed taking about access, I've tried to export the information from the table and then import it with no luck, also I have attempted to do what you suggested it does take the newer table and put it in the correct db however it puts it into unrelated...

Hello all, I have a problem which it might be an easy fix. What I have is a database that I have done some tweaking on and in the meantime the original db has been in use which has added around 200 or so more records in the table. What I would like to do is to just update the db that I have...

Hello everyone, Ive been trying to add information into a table via a subform, however whenever I setup the subform on my main form, apparently the only thing I can do is select the information from the table Im trying to put information into and displaying that on my form. This is probably...

I would of been "throwning darts in the dark" thank you myrtle for your help and especially your patience.

Myrtle, I believe I have done the changes you proposed correctly. This may seem a little trivial to you, however this is the most "complex" DB that I have done, never done anything this elaborate. I've always just dealt with 1 table, at most 2 but with no interaction between the 2. Please look...

Myrtle, Thank you for your post, it does make more sense now that you phrase it that way, and it would definately clean up the DB as well. I didn't even think of it that way, and I will have to most definitely read up on the normalization of the tables. Thanks once again.

No required fields, like I mentioned before I am VERY new to SubForms. I even used the wizzard and wysiwyg.:confused: Thank you

Do I need to add the checkoudate field. Wouldn't the phonedate, radiodate and spotterdate suffice?? I'm trying to give each one a date in the event that the employee loses the radio but was able to turn in the other 2 pieces of equipment. I still want to have the ability to pull a report like...