Search results

Spike - Not sure I am following you here. My data table ... I have to know what account number and system that data belongs with and I also need to know the date of the data. I guess I am just not visualizing the table structure any other way... Just for info here - I've imported data now for...

I'm creating a new DB to track monthly usage data. I had such a hard time figuring out how to get all the data into the database I think I may have overlooked just how I was going to use the data. I have two tables set up with data represented below. The first is the data table giving me...

I've not used the 'docmd.transfertext' -- I'm assuming that is VBA whereas I have been using macros. I really need to start to learn VBA!! :D I know there is TONS more you can do with it. Is it possible to only transfer - say line2 of a txt file into Access and ignore everything else?

I am importing data from a text file. I am going to need help w/automating this, but for now it is working. Here is a copy of the TXT file I am importing for reference to this problem... AC5FFTMP HIGHEST COUNT INFO 07-07-2011 029-001-01 00-02...

Okay ... With my limited to zero knowledge of VB I thought I would cut/paste your information into the event proceedure for a button I created. No Go. Didn't work at all. Not sure where/why yet, still troubleshooting. However, I did play around a little this morning and remembered a trick I...

Thanks SLW... I will have to give this a try. From the way I am reading this - it'll help me with importing a different file name every time. That will help to solve half of the issue... :D Next part is to get the data into a DB correctly. I've played with stuff like this in the past and...

Hello all; I'm posting this here because I think VBA or Module help will be the easiest way to do what I need to do; but I have ZERO knowledge on using VBA or Modules ... The easiest part here; is that I am creating something completely new and from scratch so I don't have to work around...

Okay.. Here's the data. I've put in my crosstab query as well. Not that it matters a whole lot, but in this test db the data in TimeSheetHrs Weekly Hrs Check table is actually a query in my main db. But the data is the same, field names are the same, etc etc... Please feel free to look and...

Just an FYI ... I didn't get the data I wanted; but I got it visually. I ran a crosstab query. That gave me a listing of all the YR/QTR/WK's down the side with a column for each employee. The total hrs populate the table. So, anyone with no entry now pops right out. Here's the query...

John; Thanks for the "Unmatched Query" Link.. Never caught that. It didn't work though.. LOL Go Figure.. I had high hopes last night after reading your post. Here is the SQL from that unmatched query wizard: SELECT [TimeSheetHrs Weekly Hrs Check].[EMPLOYEE ID], [TimeSheetHrs Weekly Hrs...

First off --- I'm not an expert, but if I am reading things right you might be creating problems from the start. You said you have a table set up for each player. I'm assuming something like: Table Player 1 Game...Home/Away...Points 1..............H................3...

Or am I barking up the wrong tree?!?! :D I have two tables I am compairing and would like to identify what is missing from one table when compaired to the 2nd. For simplicity, the first table contains 10 dates; we'll just call them 1 thru 10. The second table contains two columns, a list of...

Beetle; I agree with spike - this should be verified at entry. The DB was set up before I took over the position and updates like this was set up to be entered directly into a table without any links/verification. Had I designed it, I would have put the links in so that the data was verified...

Brian; Thanks - This did help me out a bit... But I think it's limiting me now in the 'where' clause. Or I could be wrong. I think I need a wild card here someplace. I went about this a different way after rethinking for a few days. I wrote a query that will just give me the basic stock...

Thx Spikepl... I'll have to go look at the other queries I know I can edit; but that website shows me why I can't edit the current one.. :) I've got a union in this query.. Maybe you (or others) may know how then I can pull out the data from one table that does not match data from a second...

I know that it is possible to edit data when a query is run; I have several queries that work just fine and they allow me to edit the data right there within the query. These were created long ago. However, I have written a new query but I cannot edit the data - and i need to be able to with...

Wow - I was totally brain fried yesterday. No wonder no one answered this thread... Let me see if I can clarify this all a little... Here is an example of two tables. The two columns on the left is sample data from a Parts List table. The three on the right is sample data out of the...

Maybe my brain took a vacation today; I thought this would be simple but I can't get anything to work correctly. Hopefully it's an easy oversight on my end. Is it possible to link the two tables using a wild card? For example, my Parts List table will have a stock number X But my Master...

I hope I can find an answer here... I've loved this website for years - several hard Access issues for me have been easily resolved; it's my hope that someone will be able to easily answer this one for me. Basic Setup Now: I'm in a small business that has basically one PC dedicated for email...

Amazing..... I just logged in here to post a very similar question... Not 100% sure this solution will work for me (I'm VERY bad at writing SQL). My table has over 100 columns and has over 1200 records to date. It is an invoice/work order table so many of the columns are customer/date/etc...