Search results

Sorry if this should be posted somewhere else but I couldn't work out where to post it! Anyway: I have a spreadsheet which contains data exported from another system (which I have no control over). I'm using this spreadsheet as a linked table in my database. The problem I am having is that...

I only see one table: stocklist ?

Just looked on your database and it worked fine on my pc.... I really think you should be looking at the MS Access security settings / enabling macros on your other pcs.... it's not enough to check it on your own, they'll need to be checked on every pc / for every user that needs to access the...

A problem I had the other day with a new user: they needed to enable macros on their computer before my database would work, as otherwise the code would not run! Have you tried looking at the MS Access security settings on the other computers?

Or, if you add another table in to look up the 'descriptions' : (I called mine tbl_Attend_Description, just contains the st_attend 'number' and st_attend_desc 'text' PARAMETERS [Start Date?] DateTime, [End Date?] DateTime; TRANSFORM Count(tbl_Attend_log.st_date) AS CountOfst_date SELECT...

Have you tried a crosstab query? Oh, and to simplify things, it would probably work best if you had a separate table to 'lookup' what the 1,2 and 3 mean in ST_Attend...

OK, a sample WHERE from my own database that does something similar, adapted to your field names ;) WHERE (((IIf(Not IsNull([Forms]![frmReportSelector]![OpenFromDate],qryReportSelector2_Authority.ApplicationDate>=[Forms]![frmReportSelector]![OpenFromDate],-1))=True) AND ((IIf(Not...

I just posted a reply to a thread... it's showing I've replied but when I go to the thread the reply isn't there?

WHERE (((qryReportSelector2_Authority.ApplicationDate) Between Nz([Forms]![frmReportSelector]![OpenFromDate],DMin("[ApplicationDate]","[qryAllCases]")) And Nz([Forms]![frmReportSelector]![OpenToDate],DMax("[ApplicationDate]","[qryAllCases]")))); You could try adding or...

I'm no expert on crosstabs but I think it could be because of PIVOT Format([Reception],"mmm") In ("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug"," Sep","Oct","Nov","Dec"); When you put IN like that, you are forcing it to include all those months as headings... regardless of whether there is...

YOU DO NOT NEED TO ADD ANOTHER FIELD - calculated values should never be stored, rather they should be worked out 'on the fly'.... it's simply a matter of calculating the days since the job was logged. This can be done within a query, or in an unbound text box on a form, something like (in a...

Can you not just go into the properties of the combobox, and use the build button on the rowsource?

Hmmm, must be something in my setup then, cos it never works for me!

You need to add the spaces in manually..... norm is to put & " " & between each field rather than just & Expr1: [eforname] & " " & [eSurname] & " " & [eEngineerID] & " " & [ePhoneNumber] or you could even add extra punctuation in Expr1: [eforname] & " " & [eSurname] & ", " & [eEngineerID]...

You only need one field in your table for the date and time. On the FORM, set the default value of the field to =Now() Just remember though, that if anyone ever adds information into the table directly in datasheet, not via the form, then the date/time won't be set.

You can use Date() as the default value on a field in a table, but you can't use Now() as a default. You CAN however, use Now() as the default on a field in a form! That would give you the date and time.... but if data is entered directly into the table, it won't apply...

As a minimum you would need a History ID field (PK, probably an Autonumber?), a Date/Time field to store the date/time the note was made, and a field to store the note details - this could be a Text field or a Memo field, depending on how long the notes will be. Name them according to your...

Rather than doing this.... why not have a separate table to store all the offer prices that have been made against a quotation? That way, you are not having to repeat anything... all you would need in the 2nd table is the QuotationID, the date and the price quoted (and any additional comments...

Question: why do you need the 'instructor' bit in the iif statement? Is it not just =IIf(IsNull([ResignationDate]),"YES","N/A") as the test?

Have you tried... importing the spreadsheet as a table, then deleting all the data, changing the field types to what you want them to be, and then importing the spreadsheet again into that table (rather than importing as a new one) ? I had the same problem and that approach sorted it for me :)