Search results

I have a db I need to update the information in the tables. The db has a switchboard, when I press shift to get into the controls I can't see anything. No forms, queries, forms, report nothing. I've tried compacting and repairing w/no sucess. Any idea's short of having the db restore from tape...

I have a db I need to update the information in the tables. The db has a switchboard, when I press shift to get into the controls I can't see anything. No forms, queries, forms, report nothing. I've tried compacting and repairing w/no sucess. Any idea's short of having the db restore from tape...

could some tell me what is the matter with this line of code? INSERT INTO tblLog ( TheUser, TheReport, OpenDateTime ) " & _ " SELECT """ & fOSUserName() & """ AS TheUser, 'Report1' AS TheReport 'tbllog has the field theuser, thereport and opendatetime. I'm trying to retrieve the UserName with...

Help! I established a tblLog w/fields TheUser, TheReport, OpenDateTime. I created a module to capture the name of the user logged into the network '******************** Code Start ************************** ' This code was originally written by Dev Ashish. ' It is not to be altered or...

Help. I've done this before where a command button calls up module which sends a message to EmailAddress in tblEmail. But this time on form there are 3checkboxes, if box a is checked then the message is "checkbox a was checked", etc for b and c, then the module should run. Except when the module...

I have a form that has a few option buttons on them (with y/n) values. I have the option buttons in a option group property. The group has the tab stop set to "yes". Problem is the person doing the data entry will have to take their hand off the keyboard and use the mouse, to select a Yes or...

I have a report which I've formated for vbred , vbyellow, and vbgreen problem is when they are printed they are hard to read, I searched around & read there is a list of hex values that I could use, but the value provided are incorrect. I was looking for a different /ligher shade of red, yellow...

A user recently asked me, which stumpted me, but here goes it. When the tables are opened, it doesn't maximize, so its done manuallly. 97 doesn't save the last setting. If he were asking about a form or a report, I could invoke the Docmd.Maximize, but where would I do this is a table.

I have rarely used the yes/no field, so I need some assistance. I have a few questions that need to be on a form, the questions are yes/no. I thought I would make the field type a yes or no, but then realized if a no is selected it needs to store a value of 0 and if user selects yes a 1 should...

Does work, except that I didnt' mention that only the 1st, 3rd, 5th, 7 etc (all odd number rows and all even number rows then they need to be divied) number in each column needs to be added, so I need the yes and no to return values.

the countif(xxx:ccc,"yes") will not work since in the column(s) there are other values I.e. ColumnA ColumnB Yes no Yes yes no 40 yes no 38 no I need a to sum to 41 and column b to sum to 40

Help. I have created a column with a few list boxes with yes or no into them. I need the yes or no to somehow = 0 or 1. In the column there are other numbers which need to be summed so the CountIF(a1:a11,"yes") will not work. ANy ideas?

What steps do you(s) follow or recommend to creating tables? Any standard questions? I was reading Erwin, data modeling book and didn't see a stardard check list of things to ask. I think I need to set the following up in a db, (currently in an excel spreadsheet - has a lot of Redundancy in it)...

Thank you for the feedback. I took your advise and broke down the tables. (See attached). I will have the problem, in reporting. This Db will have to accomodate many plants, and each plant has different processes (molding, paint, etc.) I was looking for ideas as to a work around for the...

Reason The db is a plant summary, so for each dept. and process (hr, quality, delivery) there are 10 fields. The problem isn't the table, since I can store 125 vallues, but the reports they want to display like its' being display now, which is in excel, with a date on top and ALL plants and...

I have a large spreadsheet that I want to move into a database. There are in one table 125 fields. I broke down the form into 2 data entry screens, since I knew there was a limit to the number of controls on a form. I was hoping there wasn't a limit on reports, but there appears to be, other...

You have to put the command button on a form. The form has to be the once specified in the startup. The code does work

can't get it to work Somewhere the code should state that you have to have a switchboard, the form opens to switchboard on startup

This are CMM dimensional reports they have to be pulled in from rtf format, text will not work

I tried it and it didn't work. I created the table and pasted in your code and it just listed all the records. I'm using 97, I wouldn't think that would matter