Recent content by snoopy4801

I'm sure this is a basic and common question, but I can't seem to find the answer for it. When i go to create a combo box in my form the option of "Find a Record on my form based on the value I selected in my combo box" is not appearing and this is the option I need. Any tips/suggestions?

Ok, so I'm a bit "green" when it comes to access.... So with that being said I have a main table in my Back end database that i need to update. What is the best way to do this without messing up the data in the front end. here is my thought initially: I have all of my data in an excel...

I managed to fix it. I'm sure i went the rookie's way around, but here's what i did. Since i could see the tables in my fe, I copied them into Excel and then re-imported them into a clean database and named the tables the same, so when i imported my reports and queries they would still work. It...

ok, so i tried that, Now i can see them all (with the same exact names) but when i try and use the link manager to link them it tells me the table doesn't exist, even though i can see it in both db's... Sorry for being a pain.. I greatly appreciate the help!

that's exactly where the problem is. there are quite a few tables that are not in the back-end, so what is the best way of getting them there, without messing up the data in my forms? i.e. if i export them to the back end and then put info in the form on my front end, will it only be updating...

I tried doing that, but it only updated a few of the tables. For the others it says it can not find the table or it doesn't exist, even though i can see it in my front end. Would I really screw things up if i exported the missing tables front the front end to the back end and then tried...

Hi All, I would say I"m at intermediate when it comes to developing databases, but am still in beginner stages for some areas, and I'm at my witt's end with a new problem and would greatly appreciate any help you could provide. here's the scenario: I built a database and split it, then...

OMG!!! THANK YOU SO MUCH!!!! That did it. Thank you, thank you!!!

Ok, so here's where I'm at....Suggestions? Do I need to take out the Inner Join? I'm really only inserting the row on the Performance tracking table, but it's linked to the employees table....:o SELECT FROM [tbl Employee Table] INNER JOIN [tbl Performance Tracking] ON [tbl Employee...

Ok, so new to SQL, probably a stupid question, but I have a performance database that i need to insert a new row for every employee for the new year and in the column "Fiscal Year" I want it to add 10. (so I would be inserting 850 records total) The SQL I am using is: INSERT INTO tbl...

We have just been upgraded to Microsoft 2007 and the problem I am having is when I go to export any report in Access it looks like when the computer is "scanning" the document somehow it pauses so what ends up being exported is my document but with a bunch of random blank spots. The odd thing...

OMG!!! We were just talking about that. If that would affect this from working, then I'm 99.9% sure that is the problem. We just upgraded and IT hasn't given us access to set "Trusted" permissions for our databases yet so we are just authorizing each session as we use them.

This is what the Event box looks like and I used the wizard to create the combo box.

See I think that is where the problem is at. If i hit enter it just moves to the next person in the list. not the person I typed in. But I did check the "After Event" box and it is blank. But I do have Limit to List set to yes. I really do appreciate the help!

I tried putting the combo box in the detail header, but I still don't get the third option in the wizard. I don't mind it going to the first name with those letters but here is what is happening. -Combo box starts with Adams -The first employee's information in the form with department and...