Search results for query: *

Hello, I have been working on the following query to determine what shift different incidents occur on. What I am getting is a 1 on some incidents and nothing on the others. The one is appearing on the wrong incidents. The field Inc Time is a military time field (24 hour clock) is is currently...

Hello, I have reviewed the posts on this topic and believe it applies to my situation, but am lost on how to implement this. I have a report that displays and then totals (in the footer) the number of transactions by type. It counts them and sums them in two different boxes. The problem I am...

I am working on a query that will be used for a report that displays the following: A user selected Job Site (tblJobSites) A Supervisor (sometimes more than one)(tblJobSiteSupervisors) and then all personnel assigned to that job site on the same days as the supervisor (tblParticipants)...

Hello, I have a form [frm paymentsentry] that has a subform launched from a button to enter in payments or fees. When the users closes that subform, I have the mainform requery using [Forms]![frm PaymentsEntry].Requery on the On Click event. The problem is that then the mainform is reset back to...

Hello, I have a form DailyDrawRecon that is based on a qry (DailyRevenue) that I am creating to get rid of an excel spreadsheet used to reconcile cash drawers at the end of the buisness day. The qry prompts the user for the buisness date and the drawer user name prior to generating the form. I...

Hello, I have a database with a main table (tblparticipants) that contains general information about program participants (name, address, phone#'s etc.). I have a one to many table that is used to track home or work visits to these participants as they occur (date and employee and location is...

Hello, I am nearing the end of a project and am having difficulty convincing the users that they do not need a report (paperbased) that they currently use. They are requesting I recreate it in Access, but have no idea where to begin. Here is the design... They currently use a report that takes...

I am working on a payments portion of a database. I have designed a Payment Entry form with an embeded subform (from a payments table) which shows all previous payments made on this account. The main form allows new payments to be entered as they are recieved at a walk up window or via mail. I...

Hello, I am working on a database where I need to insert a default value (number) into a few fields upon creation. This is easy enough to do by using the default value field, but this number will likely need to be updated in the future due to changes in fees. I would not expect this to change...

Hello, I attempted to secure a database and it appears to work. However, now I am prompted for a log in box on ANY database I access via my computer, whether they were secured prior or not. In addition, my users cannot access the new database via the network. They get an error saying the...

I have a database (Access 2000) that is on a network in G: with users accessing the data using shortcuts that take them directly to the forms that they need. (I know this isnt the best security, but it works pretty good and is about all I can manage at my level). Anyway, the problem I am having...

I have a time field (IncTime) that I would like to use to create another field (Shift) based on a specified time period. The update would only need to be done once since the IncTime value will not change once entered. For example, 12:01-7:00 am = 1 7:01 - 4:00 pm = 2 4:01 pm - 12:00pm = 3 blank...

I attempted to compact and repair a database (Access 2000) and got an error due to insufficent room on my USB flash drive. I then moved it to my harddrive and attempted it again. I now get an error box that states "Table TempMsysAccessObjects already exists" with the choice of OK or Help. If I...

Hello, I have a database with a predominate table that started with about 6 fields . I now have 7000 records in it and additional data related to the existing records has become available from another database via import from Excel. How do I "update" the existing records with the new fields...

Hello, I have a field (primary key- File Number) that is consists of the following characters >LA0000000a;;*. Counting from left to right, the first two letters (only one is required, indicate the area) the first two numbers indicate the year (yy) the next three numbers indicate the Julian day...

I have a data entry form that has a text box for entry of that date a report was approved. Currently, operators have to manually enter the date (mm/dd/yyyy). How could I automate this by using the Now() function (or something else) so that when operator tabs into the box, it is automaticly...

Hello, I am a bit new at this and have been able to accomplish both of the following, but only using seperate boxes. I would like to combine this function into one box to make data entry easier and havnt been able to find the answer to the following: I would like to use a Combo or ??? to search...