Search results

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'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...

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...

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...

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...

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...

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...

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...