Search results

I have an Employee table and sometimes needs to be updated if an employee moves to another department. I wrote a query that will select all of the employee's data. I want to use a View/Update Form that will display the employee's data, Department, Division, Cost Center, etc. However, each of the...

I have a Form that I use to view records from a Main Table. The records have an Autonumber. I also have a Remarks Table that contains remarks for each record in the Main Table. The records in the Remarks table records also have an Autonumber for each remark and save the Autonumber for the Main...

I have a Form that I use to insert records to a table. The STATE field is not on the Form, but needs to be populated on the table based on the TOWNCODE field that is on the Form. If the TOWNCODE entered on the Form is > 20 then the STATE is 2, else the STATE is 1. How can I do this?

I have a Search Query based on a Form. It does not retrieve any columns from the table if any column is empty. Why? I thought the & "*" would find all records. SELECT DISTINCT LITE.OWNER, LITE.LAMP_SUFF, LITE.LAMP_NUMBER, LITE.TOWN_CODE, LITE.ACCT_NO, LITE.STR_NAME, LITE.STR_DESC...

I have a Combo Box based on a table list on a Form. I want to choose several items from the list to feed a Lookup Query. Can this be done? :rolleyes:

I created a Form with a Header and Footer. When I see it in Form View, it only displays the Detail records. Why?

I have a Combo Box driven by a query which has hidden columns in the combo. I have created text boxes that I want to populate with these hidden columns. In the AfterUpdate of the Combo, I have Me.TxtEmpNum=Me.cboEmployee.Column(3), but I get compile error: 'Method or member data not found'. Is...

I have this Access application. The Incidents table was created incorrectly. apparently the design was not thought over. The Incidents table was created to store employee accidents. However, since the employee data is based in nicely normalized data, all Incident reports will have the employee's...

I have a Form with a Combo Box. I use the entry data from the Combo Box for the criteria in a Query. I also use the Entry fron the Combo Box as a Title Text Box in the result set Form and in a Report. Example: the Year 2007 is chosen in the Combo Box and I want to include the Year 2007 in my...

I have a Prod Table and a TEST Table, both are defined the same; same design, same key. They both have most of the same data records, except the Prod has more. I want to link both tables and update the TEST with the records in the Prod that are not in TEST.:confused:

I have a form where I mimic the filter_combobox.mdb. I have created the comboboxes, rowsource queries and afterupdate event just like the filter_comboBox.mdb example. However, when I click on the comboboxes, the display the AutoNumbers instead of the Store or Managers. What am I doing wrong...

I am trying to Hide the Database Window by unchecking the Display DataBase Window in the Startup, but the first macro with a MoveSize fails with a Condition: True, Action Name: Movesize and Arguments: 14400, 14400, 7200, 14400. I have also used Code to Hide it and get the same error. "There was...

Do I split the mdb first then create the mde from the fe, or create the mde then split it?

How can I Default a Text Box value by the input of another two Text Boxes. This Expression on the Text Box Default Value does not work. =IIf([Text0]=0 Or ([Text8]="<" And [Text0]=1),"White",IIf(([Text0]>=1 And [Text0]<=49),"Blue",IIf(([Text0]>=50 And...

I have a split DB accessed and updated by several Users. How can I limit the update of one table to only one User, administrator if you will. :confused:

I am updating a 800k record Oracle table. My Update Query runs for a few hours, then dies with a Exceeded Resource Limit error. Can I built a Macro that will run maybe 10 update queries updating 100k records each. How can I limit each update query to 100k rcords and how do I start the next query...

I have a table, to which I added three new columns. I need to populate these three columns. The data is in three columns of a linked EXCEL spreadsheet. The table and spreadsheet are joined with other columns. I created an Update Query, but when I put the name of the corresponding column of the...

I found a good place to start security: http://support.microsoft.com/defaul...kb;en-us;289885 However, since I am going to deploy the application on the network with half the clients having r/w and the other half read only, should I split the mdb first than build the security on the fe, or...

I have an application that goes directly into the Switchboard with an Autoexec. When it was in the development phase, I would launch it and it would display the Switchboard, as I expected; however if I scolled down I could see and open all the database objects to continue with the development. I...

I have a report based on a query. This query has a BETWEEN [ENTER STARTING NUMBER] AND [ENTER END NUMBER] as criteria for the NUMBER field. I want to include the [ENTER STARTING NUMBER] and [ENTER END NUMBER] data in my report. How and I capture these. The report heading will be as such...