Search results

Thanks for the reply! I have already done the first step. I have it all laid out in Excel. I'm just trying to figure out what is the best way to relate them now in Access. Also, I'm not worried about the financials and such, as I have other software for that. I'm just trying to design a simple...

Hello all! I'm trying to create a simple database to keep up with my few clients I provide service for. I'm trying to figure out the best way to relate my three tables I created: tblClients, tblDevices and tblJobs. The way I see it is, Clients own Devices that require Jobs to service them, so...

I don't quite follow you, but I will try to figure it out if the subforms don't work out. I've used subforms before so I'm confident they will work. Thank you

I've created a form to manage my clients (ClientForm), and in this form, I created a text field to list only the jobs that are linked to the current client record being viewed. To accomplish this, I'm using a list box to display the job records via a query I created (qryClientJobs), and it...

Wow! You are right, cant believe I missed that...and so much easier to execute :) Thank you!

I would like to disable the shortcut, CTRL - which allows a user to delete a record. A user accidentally deleted a record while typing in an email address that had an underscore in the email address. While trying to type it she must have hit the CTRL key instead of the Shift key follow by...

Thank you for the reply, I will change my code accordingly.

I created a basic database in Access 2013 to keep up with jobs, and each job has a job number assigned to make each job unique (Primary Key). At first I had it where I had to enter the new job number manually for each job. I have updated it and now it takes the last job number and adds 1 to it...

Thanks for trying to help, but the database you attached was very confusing for me. I could only imagine if you had tried to explain it to me without it. Fortunately I have finally figured out my issue and have successfully created a report that will only display the last note (record) of every...

I have a basic database design, well I think so anyway. It only has two tables: 1. tblClientInfo 2. tblNotes Basically each client has multiple notes/comments that can be linked to its record, hence the tblNotes table. The two tables have a one-to-many relationship, being that each...

Glad you figured it out and was able to resolve it. Do you can to elaborate how you resolved it?

Hi all! Does anyone know how to extract the comment system from the Contacts Web Database template found in Access 2010? I can upload it if you like. I would like to use it in a standard desktop database to track notes and comments in my records. I am able to convert it from web to standard...

Thanks, but I have already been there, and their example uses VBA code. The above command is suppose to just work by placing it in an empty text box in your form. You mentioned the RecordSource needs to be changed to my table, but everyone that has it working says you leave it as it is, if...

I just want to create a history of my notes in each of my records. I have spent all day, and I feel I am no closer to that goal. Searching the net, I found I could use the Column History function using the Append Only value. I thought, well this will work for now,and it should be straight...

I had edited my last reply to provide you with updates but I don't think you got them. I was able to resolve the message box without restoring, and the test code did create folders.

Sorry rookie mistake. I removed it, and even removed the button that referenced the code, but the form still produces the message box, Enter a Parameter Value when I open the Main form. I noticed the code is still in the VBA Editor and have no idea how to completely remove it for good as it...

I just had a moment to try it and I'm not sure if I did something wrong, but after making slight modifications, such as changing C drive to D drive, I get the message box: Enter a Parameter Value ID Not sure what that means, but it's not the first time I've seen it when trying to use VBA code...

Wow, much more than I was expecting! I can't wait to test it. On a positive note, I forgot that I had scanned in and saved most of the client PDFs along time ago, and had created a folder for each client. The only problem is the naming convention I used was at most, casual. I quickly entered...

It's not near as unique as the account number I have for each client, but I didn't think it wise to create folders using numbers. I like the fact that if I needed to search for a client manually I could find it much quicker by name than trying to reference the account number to a name. I assume...

Hey everyone! I'm pretty new to using Access 2010, and have created a workable database for tracking my client records. Only problem is I didn't realize that using the attachment field for my PDFs for each client would result in me reaching the 2GB limit of Access. Minor over-site, I know. I'm...