Search results

HI, I have 10 tables in a DB and one form (based on table 1) so far. I need to take the SSN field info from the form and place it into the other 9 tables. I have created 9 append queries (to update each form individually). I would like to execute all nine queries, via an on click event...

IAN, Thanks for the clarification. I have gone in an removed the word "DATE" from all field names. I'm also in the process of breaking the table up into more mangeable pieces. That large table just didn't sit well with me. Hawg1

Ian, Thanks for the suggestions and info. I inherited the database from a predecessor. I too, did a doubletake at the size of the personnel table and have though of breaking it down into smaller tables. as for the dates, they are critical as that is how we track events. Most of these are...

Hello, I've created a query that finds all of the dates for specific types (monthly, quarterly, semiannual, annual) of evaluations. It works great, shows all evaluation dates for each person. What I really need it to do is just show the most recent (i.e. latest) evaluation date for each...

Hi Again, After more fiddling and several forum searches, I figured it out. Just needed an independent query and a Dlookup to run the query and save as a variable. It may not be pretty, but it does what I need it to do.

Hi, I haven't dabbled with queries much and am at a standstill. I have a table called Personnel. Another table is called evaluations that is related to personnel via a primary key, SSN. this is where the evaluations date is entered based on the SSn selected. On a form is a combo box to...

Dom DXecutioner, Thanks for your suggestion. I did some research reading and find a method that works great. Thanks for your help though.

I use the numbers in calculations for date intervals at other text boxes.

Hi, Need help with text box issue. I have a form with a combobox that allows the user to select Monthly, Quarterly, Semi-Annual, or Annual. The resulting selection is stored in a field called timeframe on a table called Personnel; but the stored data is a number (1,3,6,12 respectively)...

dan1dyoung, thanks for info, I will look at both of those files

edojanssen, Thanks for the info

Dennisk, Thank you for the reply and the useful information. Hawg1

Hi, I'm trying to come up with the best way to limit users access to certain areas of my database. For example, I want only training managers to have access to the "training" menu item on a customized menu bar (and everything else on the menubar) and general users access to everything but...

BobLarson, I finally figured it out. I was using the module name and not the function name in the menu bar command. Changed the names and everything is A OK. :p Thanks for the help and quick responses!

Correct, I highlighted 'modules' in the Objects pane and clicked new. Then I entered the code.

Boblarson, This is what I originally had, but it doesn't seem to work. I created a menu command named 'personnel' and added '=OpenMyForm("fTest")' to the On Action box within the commands property menu. I get a message stating that 'The expression you entered has a function name that...

Hi, I'm starting to work with modules and need some help with functions. I have created a custom menubar with menus like File, Admin, Reports, etc. I would like to have my top level Admin form, for example, open when I click on 'Admin' in the menu bar. I think this can be done with a...

Hi, On a Form called "Class Size", the user annotates how many students via a combo box. I would then like a new form or even a subform to be created that contains data entry text boxes for the students name. Once names are entered, I would like to store each row as a record in a table...

I think, due to being up to the wee hours of the morning, I miscommunicated my intent. I have created a subform that has one row of text boxes for a persons first name, middle initial, and last name. On the main form, I would like the user to enter/select a number that represents how many...

Wayne, Thanks for the quick reply. I unfortunately have to state that I have no earthly clue as to what you trying to tell me with your code. I have no tables established other than the final table that I wish the 'x' number of records go to (inthe case of the example 5). I am not that...