Search results

Thought that might be it - but i am getting an error on that. "The object doesn't contain the Automation object 'me.'

Thanks! Have a great holiday yourself!

Hopefully this is an easy one for someone. I am not having luck searching and fixing it myself. I've created a form based off of a table that works great. One field is a lookup field to make sure only valid accounting code entries are made. There is another field that is temporary to display...

Minty I am all for making this easier - even if it takes a pain to convert it over. I'm not sure I fully understand your view of this though. You say all I really need is the employee ID, date, and start/finish times or hours. Yet how do I code that over to a specific account code? Did you...

CJ Yes I saw that. I just went on about the normalizing of my setup. I don't know a thing about what Galaxium said so I appreciate the link. I will read up on it tomorrow. ..

Galaxium I understand what you are saying - as far as normalization of the database; to my knowledge that is what I am struggling to do. As I mentioned before; employees fill out timesheets that list out there hours worked and these have to be manually entered. Well; I just entered 12 time...

Minty Thanks for the reply here. This is only the start of my rework. This is the main table, but the real data table is more of a sub table. The sub table will have 8 fields; first being the accounting code, then the 7 days of the week. So in essence it will store data like: 6014.23, 0, 3...

I've been playing around with a new database design and ran into a possible 'error' that I would like to avoid. It's going to be a payroll database to store time codes for hours spent working on specific projects. I have been struggling on how to put this together to fit with what we've been...

Galaxiom Okay - I think I'm understanding you. I need to set up an SQL Server first; then with my SDF file linked/used in that configuration I should be able to link the tables into Access. Since I don't have a server set up - I need to create one. I thought I had the program installed but I...

SQL_Hell Thanks for that link. It's actually one I got excited about when I found it the other day. However, me being the complete n00b with VB I was not 100% sure about everything I was reading. The answer here starts by saying you can link the table from SQL CE directly into Access - which...

I keep reading that linking or accessing SQL Server files in Access is easy and the steps seem straight forward. However, a SQL Server Compact Edition seems to be different. I've yet to figure out exactly what that difference is and/or why one will work but not the other. Hope someone can...

Nope...... No Go with that option... :(

Galaxiom I had such high hopes! Saw your post last night and wanted to try this morning. After getting to the New DSN and choosing SQL Server I was ready to make this work! Then - the balloon deflates! HAHA! I browse to the location of the .SDF file and it's not shown - so not selectable...

I've sort of already broke down what I need and would like to accomplish. To set the record straight - I mispoke on my first post. This is not a true SQL Database (as I have come to understand). It's a SQL Server Compact Edition File - basically a *.SDF file. Using MS VB 2010 Express I have...

I've not seen a FE Access with BE SQL before... Might have to look at that.

I really enjoy databases and figuring them out; but these SQL Databases are kicking my backside! :banghead: :banghead: There must be an easier way! If I could only easily (and would have to be done daily) move data from an SQL database into an Access database I would be set. I have tried...

Okay; now I am really confused. I put your code in and it worked as I wanted/expected it to. Why it didn't work for me when I was basically doing the same thing though is beyond me. Unfortunatly I didn't save my tries. Oh well. This will help me out in a lot of different queries in the...

OOPs! Yep. Sorry Plog! :D

vbaInet I tried that line of yours; well one I wrote almost identical at least; and it didn't work. Error said LEFT or RIGHT were not valid in the SQL. It looked like that command needed to be in the SELECT area only. I gave up the SQL approach. I put together a simple subQuery and...

Thanks. I know what I need to do by using another query. Was just hoping to be able to do it using a 'LIKE' or LEFT() command in the SQL. Worth a shot anyway.. Thanks!