Search results for query: *

Ok here it is. I have a simple program set up to prompt for the Employee name, id and pay. I have set up employee as a structure with three parts. My problem is with the get line that reads in the name. It works fine for the first Employee, but stores garbage in the variables and exits the...

My program figures the payroll details for two employees and then calculates a total. My problem is in rounding. My results are off by a penny. I need to know how to round a variable so that I can use it in an addition statment. Here is my code. /* Lab 03P2.cpp Name: Melissa Beyer Date...

We have checked this formula several times, but it still will not work. If the statement is true it returns the 0 which is correct. If it is false it returns #N/A. Does anyone know why. (All cell references are correct) =IF(ERROR.TYPE(VLOOKUP(CONCATENATE(A28,&quot...

I have a set of numbers that I have determined percent accuracies for. what I would like to do is display in cell next to these percents what range they fit into. (IE: 30-40% or 40-50%) Does anyone know how I can do this without making one huge If-Then statement?? THANKS!

I am preforming a set of calculations for each record in a table if it fits certain characteristics. For some reason I always get an error message that says "No current record." AFTER it has gone through all of the records. I can't seem to keep it from attempting the calculations that...

I am trying to basically take a copy of one table and add it to a pre-existing table. For some reason I can not get my loop to work right. It simply goes through and copies the same record for each line. It puts in the right number, but never changes value. I would appreciate input on what might...

I am trying to update two tables from the code of a form. When the button is clicked I would like the information to be copied to these tables. Here is the code I have so far. Can anyone make some suggestions as to why I am still getting errors? [code] Option Compare Database Option Explicit...

I am running a report that pulls its information from a query. Is it possible to do a DLOOKUP in the report to pull information from the query. Here is the syntax I have. =DLookUp("[SUMOFQUANTITY]","REPORT","[OLD MATL] = BOT30026SS") The fields in the query are...

Does anyone know the proper syntax for a repeat untill loop? I am having trouble getting mine to work. THANKS! :)

I am using a form that will be pulling from several different tables and a query. I am pretty sure I need to do open recordsets for them. I was wondering if anyone could give me a little help on how exactly to code this. THANKS!

Is there a way to have TWO DIFFERENT FIELDS filled in on TWO DIFFERENT TABLES from the same text box on a form? Or do I need to just write code to fill in one table? Thanks! :)

I have set up a dlookup function, but it keeps returning an error message. Me.PF_size = DLookup("[preform_size]", "Preform to Bottle SF and Preform Usage", "[Bottle IMS] =" & Me.bottleIMS) PF_size is the name of the txtbox I want it displayed in Preform_size...

I have a form that loads information from an internal query. Meaning I didn't create a query seperatly...it doesn't show up on the query list. It prompts for the begining and ending date then loads all records in that range. What I want to do is have and error message displayed when no records...

I am trying to display the absolute value of a field in the detail section of a report. I have tried quite a few formats but none will work. The report just says #ERROR instead of showing the value. The field name is Variance, can anyone help??

I have a form set up for data entry. When the form loads I would like it to automatically open to a new record. How can I do this without takig away thier ability to scroll through the other records?

I am working with two forms. I want to put a button on each form That will close the current form and open the other. The forms use queries to pull the records that can be accessed. Can anyone help?? Thanks :)

I am trying to set up my security. When I start the database and the login prompt pops up it works fine if you enter the admin username and password. However, I have created a user that has limited access. When the login and password are entered it doesn't work. It says they are unknown. Anyone...

My query prompts for the date, but I want it entered in a certain form. I can't get my input masks to work properly though. Whats the trick?? Can anyone tell me how to do this? Thanks, Melissa :)

I am working with a form and a table. I have the form set up this way: -->when you enter an SAP code it looks up the description for the item as well as its cost. -->When you enter the palletizer count and the pallet count it automatically calculates the difference to be put in a variance...

I would like to have my form check for duplicate records before saving. If there is an exact duplicate I would like to have it bring up an message that tells them and then gives them a choice of going ahead to add the record or not. Something like "This record already exists. Would you like...