Search results for query: *

Hi, I want to use the count function to count how many records matching combo7 and Insp_Cat = 1, then calculate 20% of the total records. then using the Update statement update the field Insp_Type to "C" limiting the number of records to 20% of total records previously calculated. This is as...

I've hit a complete blank on where to start on the following other than the pre-requisites so this is a big ask but any suggestions/help would be gratefully appreciated, even if just a starting point. Due to the complexity I've included a cut down sample version with tables etc. I have a form...

Hi, I am trying to filter one table in a form by building, then selecting WO_ID.value from a combobox48 then clicking a button to copy the PIN field for each record into another table along with the WO_ID value I've started writing the code but it's been a few years since I've done anything...

I am using a combobox CboLoopRef in Form frm_equipment to add the loop ref in frm_equipment based on the loop_ref's listed in table tbl_Loop_ref. The combobox is limited to list. The following code identifies if the new value is in the list, if it is not in the list it will ask the user if they...

Hi, Thanks for any help I receive in advance. I am trying to filter a combo box list based on the selection of a previous field. I have a main table called "tbl_equipment", two of the fields within this table are "building" and "cell". Each building has a number of Cells, each building has...

I am currently developing a database, that due to the number of fields requires several tables. I currently have "tblmain" and "tblprocess". Both with a primary key "rec" which is set to an autonumber. Is there a way that when I create a new record in "tblmain" that it creates the corresponding...

I have a form frm-export records linked to a table export records. The command button on the form runs a macro via an event procedure. If there are no records I want it to exit the sub and not run the macro. Never smile at work, they may think you're enjoying yourself too much and cut your pay.

The following is in a form with PrintedTracker as the control source. Dim stDocName As String Dim StDate As Date stDocName = "Tracker" DoCmd.GoToRecord acActiveDataObject, , acLast StDate = Me.Printed.Value DoCmd.GoToRecord acActiveDataObject, , acNewRec...

I have a tracker report which tracks the changes in my database. Currently I input the from date. Identifying the date the report will start from. It prints all changes from this date onwards. Is there a way that when I print the report it places the current date into a table and then from then...

Is there any way I can open a report and select the record source at the same time. Thereby using the same report with different queries. Never smile at work, they may think you're enjoying yourself too much and cut your pay.

I have two tables. One called Index which contains all the main data. The second called PrintIndex in which the user can select a number of records from the Index to print. I have now hit a snag. I have printed only one page of a report where the Tag is a specific record, but how do I get it to...

I am looking at creating a table and want to utilise a combo box to pull up the list of tags from another table. On selecting a tag from the list in one record I don't want that tag to be available on the next record. Is it possible to do this. Never smile at work, they may think you're...

I have a database application for instruments. The core fields in the main table "Index" are the primary key TagFunction & TagNumber & TagSubclass and InstTypes. The field InstTypes decides what form you edit the data in and what report it prints out on. There can be as many records as...

Help !!! The database that I am currently running has just come back with this error on one of the records. The database set-up is Back-End / Front-End. The index table has 219 fields in it. Which I know is why I have got the problem, I now need to look at splitting the table into several...

I have a booking form that when I click on submit form, It comes up with the following error. The web server I am on supports Frontpage Extensions so I am not sure what the problem is. FrontPage Run-Time Component Page You have submitted a form or followed a link to a page that requires a web...

In my database I have more than one table, these are linked via a query. The form I work through is linked to this query. Within the form I have a combobox with the picklist linked to one of the tables. On any record when you change this combobox is does not update the fields on the form that...

I have a secure linked database with two sites accessing the database. I want to restrict one site to only being able to update the records that are identified as "existing" in a field called "Status" but still be able read the other records but not be able to modify them. I...