Search results

Hello - I'm looking for ideas on something I've been considering for awhile. I have a database that partly deals with creating/modifying/reviewing projects. It is a multi-user database. I wanted to make it so that if a user had opened a project that it would mark it as the project was...

I have a question about Access database relationships that I've never really understood the benefit. I know we can go into database tools & select relationships to create one between 2 tables. I've never really put this function to use. When I create databases, when I need the data that is...

Hello -- I already have created & run an Access database for around 12 users. I now am looking to create a database that can have at least 30 users. Each one with a unique user ID & password (Using a security file ".mdw") Users log into a front end on a network environment. Now...My...

Hello, I have a DB that has several fields in which different times are entered. For example, when a call was received & when it was responded to. The received time access automatically "Stamps" at the table level using "Short Time" as the format & "Time()" as the default value. They can...

Hello, I have currently have a networked Help desk Database that the users log in using their actual name. Once they log in, it "Bumps" their name against the master table to see if there are any open cases that have their name associated with it. If there are, then it prompts them to...

Hello, I have one specific database that here & there I will get this message: "Could Not Update; Currently Locked By another Session This Machine". Well, I'm the only person using this database ever. It happens (I find so far) when I'm using a query that updates the date field on a record...

Hello, Quick overview so you understand: I have two databases, one which contains form(s) that allow users to enter in legal type cases. It has a subform in which has four fields to insert OLE objects. This form draws its data from a linked table in a database called Attachments. Not...

Hello, ...I don't know if this is easily possible or not, but here's my question/scenario: I am trying to create a form that allows me to (using a memo field) enter in the dialogue from a staff meeting. [This field will also be used for preparation for that very staff meeting]. I would prefer...

Hello, I have a large table that displays employees and their organization they are in. I want to create a query that only displays the ORG field, but I also only want it to display one occurance of each org. This should give me a short list that allows me to see all of the orgs in the table...

Hello, ...I'm not sure if I'm making this question more complex or not or if it's even possible? (I would think so) Anyway...What I am trying to do is create a form in which I can input more than one criteria into a field - We will cal it txtSetValues. Then via a button open a query that will...

Hello, I am trying to figure out how to use a vbYesNo msg box to open up if a specific field is left null. Field name: cbo_Status. It is a dropdown menu. If it is left null, then the popup will open offering to insert a value for them which would be "Working" or they could press no and it...

Hello, In my database, I use Access security - As it has grown new types of log on features need to be added. Currently, a user logs on and then it goes to a form that has an on timer event of which attempts to open a form that only the admin group can open. So if they do not have...

Hello, The below code I have in a module and is called by a form at Before Update. It checks the integrity of the data entered (or lack thereof) in a form. If they do not follow the guidlines and enter in the data incorrectly, it should make a msgbox with a warning message and stop the...

Hello, I have a module which contains the following code: Public Function GenerateNumber(frm As Form) As Integer On Error GoTo GenerateNumber_Err frm.Unique_Number = Format(Nz(DMax("[DAA-MasterTable].Unique_Number", "DAA-MasterTable", "Standard_Number = '" & frm.Standard_Number & "'...

Hello, I am trying to put functions into modules now. I have little experiece with this since I have always placed them directly in the forms. But I'm trying to get more organized, plus (and maybe more importantly) learn VBA more. I have this code in a module called: Number_System Code...

Hello, I have three fields that are: Standard_Number + FY + Unqiue_Number they make up a file number. These three fields are stored separately in the table as well are concatented on before update into a field called regional_number. My problem is that the user needs to be able to press a...