Search results

[Solved] Conditional Formatting of Cells based off of date and time criteria Hello, Here is what I am trying to do. I have three cells right now: Date of incident Due Date Date completed What I would like to do is the following: When they enter the date of the incident. There are specific...

Hello.. I found this code in another thread and I can't seem to get it to work. Private Sub form_beforeupdate(Cancel As Integer) Dim icount As Long icount = Nz(DLookup("EmployeeNumber", "tblMain", txtEmployeeNumber=" & Me.txtEmployeeNumber), 0) If icount <> 0 Then Beep MsgBox "Worker ID...

Hello.. I am not an administrator on our network so I can't log into a computer to try this out and I have searched and I haven't found what I am looking for. Question: If an administrator logs on a computer as the computer administrator fires up access. Can they set the default security...

Hello all... Here is what I have. A report with various calculations: Here is the layout: YesNoTypeHeader YesNoType txt field TypeHeader Type txt field GenderHeader Gender txt field Count of Gender YesNoFooter Total Females with abs sum Total Male with abs sum Total Adds both up Report...

Combo Box Filter Subform? Hello.. I have looked and searched but still can't find what I am looking to do. I have a form with a subform: frmMainData and frmSubComponent. Each form is based off a different query: frmMainData = qryLocationPhase and frmSubComponent = qryComponent I have...

Setting up a database, need some input Hello all.. I am putting together a database that will log the items that are at a location. I am looking to log the following: Location Phase Now for the rest of these items I can have more then one at each location. IE Location: X Phase: II...

Hello.. This I think is easy, but I can't put my finger on it. I have a table of processes 12 of them. In the query I have them by date. What I want to do is to be able to show all 12 processes even if there is no info in them. I have a completed button, but if there is no info in the...

Hope the title makes sense. I have a form with a subform (frmEventSubForm). I have a control on the frmEventSubform (cmdAddEventType) that opens another form (frmEventType) so that the user can update the event type. The combo drop down I am trying to update is cboEventTypeVer2 on the sub...

Hello.. Here is what I have. The database is made up of three tables (see below and see attachment). I have it set as one event to many ethnicity's and many personnel with the event ID as the PK in all three. Did I do this correctly? I thought I did and I had a form with each one of these...

Hello.. I am new to split database format... If I put the backend on say windows server 2000 or 2003 in a folder, is there anything else I need to do? Any setting on the server?? Or do I need a specific type of server os ie sql server etc? Thanks

Hello.. I am having something weird happen to one of my databases. I split the database. That worked fine. But now anytime someone opens it up.. a database1.mdb file is created in the spot I split my database in. If it is opened again.. database2.mdb file is created and so on. Has this...

Hello.. I have a one applicant to many callers database setup. I want to be able to see only the last call to the applicant based on date. I have tried the following: SELECT tblApplicant.ApplicantID, tblApplicant.ApplicantLName, tblApplicant.ApplicantFName, tblApplicant.LastFour...

Hello.. I have a query that has multipal parameters for that query. I want to be able to set it up so that the person doesn't have to use all the parameters.. IE then can use just the dates, or just the test type etc... Here is the sql that I am currently using: SELECT...

Hello.. I have a form with three tabs. Event Personnel Assigned Break Down On the event tab I have a txtbox that is supposed to pull from the footer in the break down tab the sum. I can get the sum to work on the break down tab but I can't get it to pull to the event tab. I keep getting...

I have two forms that have a link to open the same form. IE Test taking Form Survey Form they open up this form: Update jobtitle form Both the test taking and survey forms have a button that opens up the jobtitle form. I have it set when you close the jobtitle form that it requeries the test...

Hello.. I have a report that is based of a query. In the query I have the following calculation: total: ([quanity]*[packagecost]) I have also been able to group the like products, but it does not add the quanity correctly. Here is the sql of the query: SELECT tblOrder.OrderID...

Hello... Question, do you need one for your database and if so why? I have read what they are but I haven't found really why you would need it? Don't know if this is the right place to post this question but wanted to get some input on this. Thanks R~

Hi all here's my question. Have report based on query. In the query I have items ordered by unit "unit is IE personnel, Exams, etc.... Example: Personnel,,,,,computer,,,,$50.00 quanity 2 part number 345 Exams,,,,,,,,,computer,,,,$50.00 quanity 1 part number 345 In the report or query how...

Hello.. I have not run into this problem before and it has me stumped. I have a form that is based off a query... I then tried to create a drop down box so the person can pick which vendor for this order. But it will not let me pick the vendor. I get a beep beep when I try to pick one...

Hello.... Here is what I am doing. It is an inventory database that also is an order tracking per se database. When you are entering in the order, the top part is the vendor with an order number, date etc (will show table later). The subform is the order details. This is the tricky...