Search results for query: *

I am trying to import a xls sheet into a new table in current ACCESS database. I am using the wizard am getting the error " the search key ws not found in any record". File was not imported. I went through my file and included a key identifier...do not know why it won't import. please advise

Thank you all... Brad your formula works perfectly... Many Thanks to all!!

I have a column of numbers, from 1-5, and the rest are blank. I want to make all of the blanks N/A, the formula I have been struggling with is not working (have a feeling I am over thinking this).. I want to leave the 1-3 as they are but change the blanks to NA =IF(OR(Q3="1",Q3 ="2",Q3...

Yes, see attached, shows my query set up... see that some fields have values for MDEP others do not.. if they don't have a value I don't want them to show up on on my form. The problem is that I can't exclude the field name ( use the don't show option) because in some cases the field is...

I built a form for 154 records, but I don't want the form to displace a field if the results are blank. FOr example,years 2000-2010, I have one customer that has data for all, but another that only has data for 2000-2005, I don't want that record to show 2006-2010 field names when the data would...

I am in Acces, right clicking to export to PDF, but it won't allow me to export, it wants to print only. Is there a setting in Access that needs to be set so it will allow me to convert to PDF but not print? When I hit export, PDF.. I get the err This document was preivuosly formatted for the...

How do I see what the size of each of my tables in a Access 2007 database?

What is the .ldb file?

I am not repairing or compating. A user will go in first thing in the morning and it will be read only.. any suggestion how to fix it?

For some reason my database on the LAN keeps reverting to read only.. I will be in it one minute, close it, then go back into it and it says that it is READ ONLY.. is there a feature that i have on that I don't realize that is causing this? Please advise.

Within a form, I have a field for updates, once the user puts their update in ( or right before) I want Access to auto generate a date stamp. How do I do this?

I am trying to make changes to my switchboard, but when I try to close it asks me if I want to save, I say yes, but then it doen't close, nor does it close.

Yes it is a form.. also. Sorry for these silly questions but I am new to the coding stuff, I usually used macros. What does this mean "Next, you will need to pick an event, the Before Update event of the form is usually good"?

I have tried using the expression builder IIf[taskers].[status] ="completed", [taskers].[completed date] <> NULL.

How do I write a validation that says "If the status = "completed", then the completed date must be populated"? Thanks diana

An autonumber has no meaning other than unicity, dot. What does this mean.. laymen terms if possible.. thanks!

FOr some reason it started back at "1" now, but its not numbering as it suppose to. I wanted it to start numbering at 1 with the latest date first... so as new records are entered they would be in order... for example 7/8/2008 is number 159, and 12/10/2008 is number 1.. how do I get the...

Yes I checked to make sure it wasn't on random. Thanks!

Yes there were, 102 liness

I using autonumber, but it is starting at 6299978, rather than 1. It is the first record in my database. Why is it doing this?