Recent content by Preyzar

Thanks peeps, after a little more playing I got it to work. :)

Well, a couple of more hours into it and I haven't been able to get any further in solving the problem. A Google search (with a different string) brought me to a suggestion of using the wizard to import to a new table, then using an append query to update the table you want the data to end up...

Hi all, I was having a problem with getting my import wizard to work, so I posted here and was, thankfully, pointed in a direction that may lead me to solving the problem. The poster suggested I import the file into a new test table, print off the properties of the test table (I used the...

I've done the first part of this and printed off the table documentation to match the properties of the live table up to the test table. I'll give the rest of it a whirl later today and let you know how it goes. Thanks all for all your suggestions!

I've been caught with that in the past too, so that was one of the first things I looked at. Ctrl-End in Excel took me to the appropriate last cell in the data I'm trying to upload. Bolded header rows have stalled me before too!

When you say by hand, I'm assuming you mean copying and pasting directly into the tables? If you do mean by the copy/paste method, I'm not getting any errors which is what's leading to my frustrations. It would be easy to identify then which field in Access or column in Excel is the culprit...

I have a similar situation - our period ends do not coincide with the actual end of the month. I've used a TimeDimension table that I've populated manually (copy/paste from Excel) with the date as the primary key. Each record describes which period/fiscal year and calendar year that date...

Any insight you could offer would be greatly appreciated!

I recommend you use a Job table that describes to the header portion (ie. JobID, job name, customerID, etc.) and then you'll be able to have many line items relating to a single job in another Job Details table (ie. JobDetailID, JobID, etc.) You can then build a query that will return all line...

You could use an append or update query.

If I'm correct in assuming what you really want to see is all the info showing up so you can create an invoice using Reports, you would combine the data you want in a query, not in a table. Properly normalized tables shouldn't have duplicated data which would be inefficient and redundant.

You can include the calculation as one of the fields in the query (ReferBackDate: [ExpiryDate]-180) and set the criteria on that field - just insert the field into the existing query you are running under the report.

I think the easiest way for you to solve this report problem is to have the report run from a query rather than directly from the tables. With the query you can set parameters in the date field criteria line such as: BETWEEN [Start date?] AND [End date?]. You'll then be able to run the report...

I misspoke... The window that shows the tables, queries, etc. will be hidden so he won't be able to see them. If he really wanted to (and knew how) he could unhide the pane and then have access to them, but that's unlikely, lol.

I did try that - I still get the message. The Access Help menu just says that I need to ensure that the formats, number of columns, and column headers must match - which they do as far as I can tell.