Search results

I have a report from a db that seems to print 2 copies when printing. I am trying to find out how to stop this. This is the only report that does it. Is there a setting I can look for?

When I open the database, it opens fine. Then I click on the button to go to the form. But, when I close it if you look at the top where the form meets with the access windows it seems to kinda jump a little. Not sure how I can fix it? Rob

Thanks I will see if I can find something here. I am still a new access programmer. I can do the basic stuff and a little extra. Maybe someone can help. Thanks

ok I did that and still didnt work. when I am in the empid 1 which has the number (516) 222-1111 and if I search for (222) 222-2222 which is located in empid 2 it doesnt find it. it seems to only search in that record. for instance in empID 2 there is (333) 333-3333 And (222) 222-2222 I can...

sure thing. I had a long day to. Ok say I want to search for a aphone number in the field Cell number in teh cell subform. If I click in the field and press ctrl F. I get the find button. If I search for a number that is not in that record it will not find it for instance. in the first...

can someone take a look at my subform database that I created. I would like to know if I go into the cell tabel under the field number and search for the number 3333. Why does it not go to the second record in the db since that number does show up? IS there a way that I can search for...

I am getting an errror when trying to relate a table, enforce referential integrity are violated on the many side of a relationship what does that mean exactly. Rob

k I changed I realized that I need to have a primary key in the cell table. Can you look and tell me what you think I should do to improve if needed.

I have a table that has user information EmpID FirstName LastName Site Phone Voicemail Modem then I have a table that will hold the cell phone list. which consit of EmpID CellNumber Model SerialNumber Active DateAssigned This would be a 1 to many relationship but not sure what I should...

how would I set them to null. just put a blank???

would blank records give me a problem???? Now link the tblDepts DeptK (primary Key) to the tblUserNames DeptK (foreign key). Let me know if this resolves the issue. this I know would work but I was trying to avoid this right now.

I have a table that has user names and they are associated to department. I am trying to use a relationship between the two tables the states table has ID and Department Name when I try to relate the 2 tables I get an error message I have attached it here.

I would like toknow is there away to create an input where I can tell access what information to use to make a quiery. instead of making individual quieries. For example ifI wanted to have first name last name and address. say the next day I wanted first name last name and just phone number...

no its not a gif. The extension is .mmc

I have downloaded a picture from Microsofts http://dgl.microsoft.com website. the picture is animated and won't animate in access? How can I get this to work? Rob

I am talking about when entering info not viewing it.

Is there away to foce capitalization on a person name even if there for example SMITH SMITH /JONES

this is becasue based on someones excel spreadsheet and they want this, I might do it the other way but how do I do this??

kool thanks is it the same way if I want 2 have 2 dates in a field I will try it when I get home but was getting errors.

I want to be able to enter either 516-222-1111,____ ___-___-1111,____ 516-222-1111,3333 as the input mask for phone numbers what would be the format???? I tried a couple different ways but its not working