Search results

Hello, I've previously posted this question here: http://www.access-programmers.co.uk/forums/showthread.php?t=168702 but thought I would open it up to the rest of the forum for assistance. I have a query that identifies categories of things that don't have any additional data entered about...

Hello, I have a database where project managers enter information about the status of their projects quarterly. This is something they will need to do each and every quarter. I am trying to create a query to determine who has not entered anything for their product in a given quarter so that...

Nevermind, I solved this right after I posted. Please delete, mod. Thanks, CF

Hello, I downloaded Ghudson's file here in order to allow my users to view documents relevant to the record they are viewing in the database. I've made some slight modifications so that the code pulls all the file links from the directory into a table. The code then scans the entire title to...

Hi All, I have a database that tracks work flow. The flow is as follows: 1) employee receives work request 2) employee performs some tasks related to that request 3) employee needs additional information, and pauses work while wait for that info 4) employee receives additional information and...

This forum is so incredibly helpful! Here is my newest question: Is it possible to check if a given user is opening the db for the first time? What I would like to do is have a message box distributed with my updates that details what the changes are. So the first time each unique users...

Hi, I was testing out some code I found on this website and other MVP locations to hide all the menus and disable the Access close button. It would then make sure to reverse before closing the database. I also created a button to bring everything back. This worked like a charm for about an...

Hi, I created a continuous form that shows a a series of records in my database so the users can quickly scroll through and select the one they want. Each record is either keeping track of a business or an individual person. These names are stored in a table in three fields - the individual...

Hello, Having a conceptualization problem here. In my database, every entry has a risk code from 1 to 100. For reporting purposes, management would like those grouped into ten catagories. As it stands now, I have three tables - one that holds the entire entry's information including the...

I am in the process of creating a custom autonumber (I know, I know, it's not my choice. I'm just following orders). I've got it down so that the number works and increments every time someone opens a form to enter a new transaction. However, I could only get it to work if the text box is...

Hi, I have a form that is linked to a table and displays employee information (address, phone number, etc). It shows this information for both work and personal. I would like to set viewing privilages so that managers can view all the information for everyone, all employees can view...

I'm back with another validation question. I've read the descriptions of when different events fire, but I'm confused as to why this one is messing up my form. I have two txtboxes: DateReceived and DateCompleted. The data may be changed at any time. If information has been...

Hello, I have a form where people enter information on a new work order. Among other things, they must enter the status of the order (open, closed, dead, more info requested), the date the order was received, and the date the order was completed/dead if applicable. I'm trying to write a...

Hello All, I have searched these forums for multiple days now, and attempted to reverse engineer just about every post on searching from forms so that it works for my database, but, unfortunately, I'm simply not good enough at VBA to get it to work. I would love it if someone could please help...

Hello, I think that I've read all of the posts about searching on this forum and they either aren't what I need to do or I'm too ignorant of VBA to understand them and I would really appreciate some help. I have a form that opens when a user opens the database and I would like it to say...

Hi Everyone, Here is some code to predefine different color variables to make your life easier. This is provided by Alan Simpson via Access VBA for Dummies and is reprinted with permission. Enjoy! Sub DefineColors() 'Delcare color names. Dim Beige, Brown, Chartreuse...