Search results for query: *

I am trying to create a form that will add mutiple records to a table. What I need is a form to fill in data in this manner. Hour A-Temp B-Temp A-Press B-Press 2400 27 89 46 67 0200 0400 0600 etc... I need the form to look like this with the hours...

Searched but could not find an answer to this one. I have a form that runs a query that returns a set of records for a report. The query has a date field that corresponds to the field on the record. My form has Unbound text boxes for to and from dates. I want to be able to query the records...

I know multi select list have been discussed several time but in reading through them I am still stump on what should be a simple solution. I have a employee table. The table columns are: ID(Key) Name Active (Yes/No check box). I am try to create a form with a multi selct list box so I can...

I have a form that opens for edit the last record in the table it is linked to. It opens just fine to the last record, but it allow you to also go back to past records by scrolling with the mouse. My form is long and so out of instinct people use the scroll button, which scrolls backwards...

Hello All, I have had this database for a few years now and just used it 5 days ago. Went to open it this morning and got an error message Stating, "This member of the replica set will expire in 6 days because it hasn't been synchronized with another member of the replica set.If the member is...

Hello all, I am a casual user of Access and am having a problem with a report. I have a form that has 8 text boxes that can be used to input information into for Inbound and Outbound item. This updates a query, and I have a report that uses the query to return the information. What I can't...

I am trying to compare a cell to 60 other cells and if it is the same as any of those cells put that information in another cell. Example: If A2 is = to any cell from Q2 through V11 then I2 would = A2. I know this may be a simple formula but I am lost on how to do it. I have a very limited...

We have a excel file that is stored on our server. When someone opens it for editing and closes it sometimes it won't allow anyone else to access the file for up to an hour later. We get the error message: "Filename.xls is locked for editing" by 'Administrator' No one has the file open and...

I am trying to lock a merged cell out so only certain individuals can access it. I have went to tools/protection/Allow users to edit ranges and filled in the names and entered in a password along with the merged cell range. Next I went to Tools/protection/protect sheet and protected the sheet...

I have an Excel spreadsheet that has data entered on Wednesdays and Saturdays only. What I need is a way to put the dates in for Wed. and Sat. and then drag the cells down to fill in the series so I have the dates filled in for just Wed. and Sat. all the way down the sheet. I have tried several...

I have a query that I need to have the most recent training dates brought into, not sure where to go from here, any suggestions? Here is the SQL view of the query. Thanks for any help/suggestions. Chris SELECT tblEmployees.[Employee Number], tblEmployees.[Employee Full Name]...

Hello All, I have a query that calculates dates and would like to format the date field fonts to be red if the date is less than todays date. Is there a way to make this happen in a query? Thanks for any help Chris

Hello and thanks for any help, I have a cross tab query that has training courses as the row header, employees as the column header, and the training dates as the fields. I want to be able to get the most recent training dates drawn into the query. Is there an expression that would give me the...