Search results for query: *

I am using 2 <div> tags within a <div> tag and I am trying to put a border in the outer <div> and it's not working. Instead of a border around the outside, I only get a thick line at the top. I am trying to float the inner <div>s to the left and right using relative positioning on the outer...

When I started my computer, I had a message something about a problem with the registry and it had been successfully fixed. Unfortunately, I don't know exactly what it said. Howerever, now I can't open any of my applications by clicking on them. I have to right click and open. I sometimes get...

What is the maximum amount of text you can put in one cell in Excel? I would also appreciate if someone could give me a reference. Thanks, brbarto

I have created a couple of standard forms that I want to be child forms. Someone else created the MDI form. I have tried to add my forms and then change the MDIChild property to true, but this doesn't seem to work. We have command buttons that the user can click on to open these forms, but when...

I have an Account table. The primary key is account number. The account number has a hypen in it. The account numbers are now being changed. The hyphen is being taken out and a number is being added. I have the old and new account numbers in Excel. What is the best way to update the Account...

How can I do something like this in code? Sum(price*quantity) Thanks(very new to access/VBA)

I was doing this calculation =[Gallons][UnitAmt] and was having trouble with it not rounding correctly. UnitAmt is Currency; Gallons is Double(fixed, 1 decimal place). To correct the problem, I think, I changed it to =CCur(NZ ([Gallons]*[UnitAmt])). I don't really understand why CCur is...

I have a combo box (LastName) on a subform (driver infomation). (The main form is the vehicle rental request.) The user picks a last name (or types it in). The SSN is what is stored. How do I make it required that the user must enter at least one driver? Thanks

I am getting the following message when entering data in a rental form. I get the message when I enter the VehicleNumber(combobox). The PickupDate is further down on the form and yes it is required. It will allow me to continue entering. &quot;The field tblRental.PickupDate cannot contain a...

Can I use IN in an if statement? If so, how?? How would be the best way to do the following? If Me!VehicleNumber.Column(5) IN(&quot;820&quot;, &quot;822&quot;, &quot;824&quot;) And [EndMileage] - [BeginMileage] < 1000 Then Form!fsubPerMileCharge.Form![Quantity] = 1000 Else...

Is there any reason the Required property in the field properties needs to be set to Yes for the primary key? Does it matter? It appears that if a field is the primary key, it is required, but the Required property is not automatically changed to Yes? Thanks

I am trying to create a report that shows the acct to be charged, the acct that receives the revenue, and the amount, so I'm dealing with AcctNumber, RevenueAcctNumber, and ChargedAmount. The user wants it broken down by RevenueAcctNumber(there only 2), by AcctNumber (all accts starting with...

When I try to open my WorkOrder form, I get a message that the macro 'WorkOrder Menu' can't be found. It was OK until, I think, I deleted a macro and replaced it with an event procedure. I had a macro(OnOpen) - GoToNewWO ( Maximize, Go to Record (Form, frmWorkOrder, New)). Then I deleted the...

A newbie question: I know you can query a query, but how many levels of queries can you do?? For example, can I do a union query on several queries, which some of them may be based on a query, and then do a query on the union query? Thanks for any comments!

I am doing a summary report. The acct#, acct name, etc, and total are in the acct# footer. I need to group by the first number of the acct#. Is there some way to do this? Thanks

I am doing a summary report. In an Account footer I have an AcctNumber, AcctName, etc, and a calculated total. Actually, I want to include only those accounts with a negative total. I am able to put code in the OnFormat or OnPrint event (not sure which one to use) and get a row(positive totals)...

I have a report with several subreports. In the footer I total the subreports. Is there some way I can just print those totals that are positive (or negative)? Thanks, NewToAccess

I have a summary report that lists accounts with total charges. (These charges are calculated from several subreports of the different types of charges.) In the account footer, I calculate the total for each account. I really need to group the negative totals from the positives. Can I do this...

I have created a combobox with account numbers. I am having problems, I think, because the numbers (ex 2-70000) have a hyphen. I was never able to get the hyphen displayed in the combobox. Is this possible?? When an account number is selected, then a hyphen will appear on the form. I am using an...

I need to print a &quot;44&quot; (earnings code) in a report if the AccountNumber starts with a 2; otherwise, I need to print &quot;45&quot;. I am dealing with account numbers 0-00000 to 9-99999. I think the account numbers are stored without the hyphen. (I am using an input mask, 0\-00000.) I...