Search results

Hello everyone! I am using A'97 and have built in user-level security, my question is this: Is it possible to reference a security group account for a particular function in code? For example: - I have a form that has a command button to go into previous records, (The default I set was that...

Question for the masses: I have a report that is exactly 1/2 of a normal 8.5 by 11 sheet of paper. What I want to do is have the report print itself twice on each sheet of paper. The group I am building this database for have a receipt report that has to print 2 copies (1 for record-keeping...

Question for the masses, I have a cmd buton that runs a delete current record operation. I have the code set up so that when pressed, an input box tells the user that the supervisor must enter his/her password to complete the function. The code is listed as follows: Private Sub...

Good morning all, If someone could help me out on this I would really appreciate it. I have posted this question a few times in the past and many people have jumped in to help but unfortunitly non of the help I have recieved in the past has worked. Anyway, enough with my begging, here goes...

Question for the masses: Does anyone know if there are different formats for currency in A'97? I checked the help files but found nothing... Thanks in advance, Kevin

Another question for this fine morning!, I wanted to use a MsgBox with the Vbyesno buttons. DOes anyone know the way to code these buttons so you can have then either (1) - Open a form with the Yes command (2) - Close the msgbox with the No command and resume function If someone could help...

Good morning all! (I know I'm pretty perky already this morning but I'm on my third cup o' the juice ) I have a question regarding currency conversions: Is there an activeX control or some other downloadable appendage to deal with currency conversion issues in Access 97'? If not, I need a...

(v. '97) I have read previous posts, microsoft support database, help, other examples(northwind, Orders) and I still cannot get this thing to work so I am bring it to you good people for some help, here goes: I have a form that has 2 catagories of information: 1 - customer info, 2 -...

I haven't been able to find the answer to this on my own, so I was hoping one of you good people could help me out! I have a form, [products], that lists sale items. At the bottom of the form I have 3 txt boxes that sum up the information. The first txtbox, [sale_total], calculates the...

I have a few option groups and combo boxes that store a number value for selected entires. The problem I have is that when I print out my reports I want to transfer those number values back to text. i.e.: 1 = blue 2 = red 3 = yellow etc.... Does anyone know the best way to accomplish this...

This question was posted below but some additions have been made by the client and so I need to ask again, (please bear with me) I have a field in my customers table named: mc# This field is a unique nuber for each customer. What I want to set up is a combo box that: (1) when the user...

I'm sure this issue has been discussed on this forum many times but I couldn't find the answerwhen I went back through the last couple of weeks in this forum, (or in help). If someone knows the answer to this I would appreciate it! I have a table for customers. In order to keep the integrity...

If anyone has read my previous thread they know the pain I am in... this problem could be the solution to all of my problems so any help on this is FULLY APPRECIATED: My question is this: Is it possible to write code for an unbound txtbox that could evaluate a previous field and preform 1 of 2...

I'm sure this is a simple question for most of you but this has been driving me bananas.... Please Help. My problem is this: I have an unbound text box that preforms a calculation on a form. What I want to do is store this value in a table for later use. The problem is I don't know how to...

I have a form which calculates sales. At the end of this form I have a command button which I want to use to print out a reciept of the transaction. The command button is linked to a report name "receipt". The problem that I'm having is that when you click the command button it prints the...

I have hit a brick wall with this one so maybe some of you could help out... I have a form entitled, "Database Introductory" Form. The purpose of this form is to gather information on the initial start up of the database. This info is data that will be used through out the rest of the...

Short and Sweet: Is there a way I can save data in an unbound textbox to a table? I have an unbound box performing a calculation and I want to have that total saved in a table... Any help is appreciated!!!

I'm having problems getting this to work so I hope maybe some of you can help with this ... I have a form that performs sales calculations. At the bottom of the form I have unbound text boxes that add the totals, figure the sales tax rate, give the toal due, and also make change from the...

I am having trouble with Access displaying text on a main form... I have a text box in the form footer of my subform which preforms a sum calculation of my transaction totals. I have used the code: =Sum([Unit Price]*[Quantity]) I then placed an unbound text box on my main form and usd the...

This issue has been driving me bananas so if someone could help I would really appreciate it!!! I have created a database to track sales. I have 3 tables: "Transactions" "Transaction Details" and "Products". The setup is very similar to the orders entry sample database. What I am having problems...