Search results

What I'm hoping to be able to do with this data is eventually find a way to use Access 2016 as a sort of Point of Sale program. I already have a barcode scanner that I can get to work with Access, so it's just a matter of putting all the pieces of this puzzle together. Thanks again for all of...

Awesome. Thanks for the 411. I'm gonna take this info and see if I can get this project started. I love this site :)

Thank you both for replies so quickly. I have an idea of how I want this to work, but the challenge is trying to put it into words how I want it to come out, and the even harder challenge is trying to make it work in Access. As far as the ideas you gave, that's pretty much the best info I've...

Hello all. I run a cellphone/PC repair shop, and I am trying to find a way to keep up with what comes in and goes out of my shop. I want to create a DB that will allow me to keep up with: Customers Devices Repairs and find a way to link all of these, since they are always interconnected. For...

Well, I'm currently working on getting everything the way that I want it. I think my biggest holdup was all the different relationships on the example you showed me. While I do think that I need more than a few tables, I don't need quite as many different fields OR tables. So instead of hacking...

Thank you for the speedy reply! Well, as for the website you listed, that is a very detailed system of tables, which is WAAAAY more than I would need. Overall I'm only going to need 5 tables max. 6 if I create a login splash form. But using the example listed, let's say I opened up the...

Hello all, It's been quite some time since I worked with Access, and unfortunately, it's not exactly like riding a bike. I've forgotten a whole bunch of stuff. I am wanting to create a db for invoices and price quotes for the business that I work at. We currently use some dinosaur of a program...

After lots (an I mean LOTS) of trial and error to get this to work like I want, I think I need a new approach. I read online about using something called a recordset in VBA. Could I apply this since the data is in a table, and maybe use if/then statements for the rest? Thanks again for all the help!

Okay. I think I'm getting closer to what I need. Something like this: I have a table that has 5 columns: Marital Status, Exemptions, PayMin, PayMax, and Withholding. I need to run a dlookup on this table based on the number of exemptions and marital status, as well as find the amount between...

Thanks for the reply. Here is the breakdown... The data is the federal withholdings table. My lookup criteria are the amount of gross pay (ex. between 175-185) and the number of exemptions. I need this data to automatically retrieve the correct amount of withholding based on these two...

Hi all I have a batch file that runs when I click on a command button on a form. It makes a backup of all my files and resources for the database. When I click the button, Access gives me a warning saying: Opening G:\PayrollDataCenter\Data\Resources\PDCbak.bat Some files can contain viruses or...

bump........

Hi all, Not sure if this is the correct forum, but here goes. I am creating a payroll db. The project is all but complete. The one thing I would like to do is find a way to perform data retrieval based on criteria. On the actual Payroll form, where the employer will figure up the check amount...

Thanks for the info guys. I've never used global variables before. How would I use one? Does it need to be public or private? I guess what I'm asking is how to I make one and use it with VBA? I've tried to look it up, but I get misdirected a lot.

Okay, I've got this narrowed down just a bit more. I converted the data in my combo box (the user name) to a string and called it into my table (same thing with the time stamp). Now, when I click the logon button, a record is made in the Log Time table with a User and a Time In. The Time Out...

That is what I needed, yet I'm still having some issues. The login form I use gets data from a Users Table. It has an ID # (primary key), Name, and Password. I've applied the code to add a record to the tblLogTime for User and TimeIn. The code works and adds a timestamp, but in the User column...

Hello all! What I am needing to do is create a table that logs whenever some one logs in, and then when they log out. I've created a Multi-User Login form, and my splash screen has a logout button which takes you to the login screen (and if done correctly, creates a record in a table every time...

This is a bit of a twist on this thread. I have the same issue, except that I already made the query with the Name, Start and End Date. What I want to do is add a combo box that allows the User to pick another field to add to the query (or just select a field to sort by). I've tried to write...

I think I've found a way to specify what it is that I want to do. By the way, thanks for the link, but to be honest it was a bit over my head. The search form I have has a combo box for the name, and two textboxes for start and end date. The second combo box, I want to select that field from...

Thanks for the welcome, sir. Here is the issue. I have a payroll database, that has a table for Employees, Payroll, and Users (for logging in). If I want to create a report, I can make a query for each of the fields that I wish to sort by in the report (without including each and every field in...