Search results for query: *

[2thumbsup] I moved everything into the Box Number header exception for the Contents control and it works great!!! Thanks...stars for GingerR and dhookom!!

There is a seperate record for each item. 'Item 1' is essentially record 1; 'Item 2' is record 2...so on and so forth. In my report, there is both a BOX NUMBER header (contains box number & account number) and footer (contains a page break).

All of my data on the report is coming from 1 table. The structure of the database is jacked...but I have to work with it as is because of how it's linked to Sharepoint. I can modify/create/delete everything BUT the table structure. Table properties: Field name Data Type ID...

It is grouped on Box Number. No, there's not a seperate page for each record. Continuing with the example I used in my original post, My report looks like this: Box Number 1234 Account Number 7777 Contents Owner Jane Doe Contents Item 1 from record 1 Item 2...

I haven't posted in a while, but this one has me going crazy! I have a table that has a dynamic link to a list on Sharepoint which provides the data for my database. I have created a report that will serve as an inventory list. I created a a form with an unbound combo box that is used to...

Okay...same form, new issue. I changed the original code as suggested in the above posts. I created in If statment to either open the correct IndivData form or return a 'Not Found' message. It still worked fine until I added more code to set the unbound fields to null after the If statement...

Thank you both, 930driver & PHV!! The simplest things can be the hardest, huh? I learned something new: [smile]Tiffany[smile]

I have a form called (Find Employee) set up that is only used to find records from a table (BadgeData) and returns the record on another form (IndivData). On the Find Employee form, there are three text boxes that are unbound but exist in the BadgeData table(Badge Number, FName, & LName). I...

Awesome! It worked...now I have a great example of how mine needs to work. Thanks SOOOOO much for your help! [smile]Tiffany[smile]

You are exactly right!! I couldn't figure out any other way to ask questions about this. I copied the code from your FAQ a few weeks ago to give me a reference for what I want to do. I created the whole thing as your FAQ said to see what it would do & how it would work. The form wouldn't ever...

I am fairly new to Access and even moreso to coding. This database is the first one I've ever had to creat for work purposes. I am working on secuing the DB and got some help with a form for Users to change their passwords. My little helper is no longer available![thumbsdown] Can someone please...

Yes, there is a default network printer installed, but Access doesn't appear to recognizing it. I can print from Access, but I have to do File|Print|.... The problem I'm having is with the various items that Access creates and sends to the printer on it's own. I hope this makes sense.

I began working on a database a couple of months ago. Since then, my office has relocated. I am still on the same network, but my printers have changed. There are items within the database that print automatically that will no longer print becaus eof this message. For example, I cannot use the...

All - After hours of going through some more posts on the forum I found a thread that really helped me figure out what I was missing (See Thread701-909427). Here is my new query (SQL view): INSERT INTO Updates ( CardNum, AutoNum, LastReauth ) SELECT BadgeData.CardNum, BadgeData.AutoNum...

I'm so sorry...no...no conditions

I will try this. Will this work if the form contais more than one value for CardNum. The form that this data is coming from is a continuous form and may have more than one record on each form.

I did mean an Access macro. I only converted it to a module in order to post it here on the forum. I really hate to sound so dim-witted, but I have no idea what your last suggestion means.

Correct, the query shows no records when ran from the macro, but provides the specified record when ran manually. [sadeyes] I'm starting to thing that there's somthing missing in the macro. What do you think?? '------------------------------------------------------------ ' SubmitApprovalForm '...

No, when the query runs within the macro, no records are selected.

sfreeman, I tried what you suggested and it still does not work. When running it within the macro, yes, I'm using OpenQuery. Could it possibly be a violation in the tables' relationships??[ponder]