Search results

I've got my test dB working. So I need to purge out the data from a table with 900+ rows. Can I do that in one fell swoop. Instead of a row at a time?

I am using a canned download from MS to handle contacts. So I entered the mask > which is supposed to convert everything to capital letters. But nothing responds? I want to type with some speed and not worry about hitting the cap locks.

I can make the DATE picker work, but I need to add the TIME to the same picker. At least that would be preferred.

I can make the date picker work. I also need to be able to choose a time. How can I make the date picker include a time?

I can build a table and form for our "Parts Inventory". No problem. I can build an "Order form" for orders that identify the parts. How do I get the "Order form" to delete the parts or update (reduce) the "Parts Inventory" table with the reduced products? Conversely I can build a "Form" to...

I have a table with about 290 record. When I'm in the "Form View" and click the "Next Record" arrow it scrolls by order of Employee instead of the primary key "Record Number". Why is that?

I'm on the verge of updating my PC tower. I hope to build some runtime apps for sale. I'm using Access ver 10. Is their a preference to either the 32 bit or 64 bit computer.

Is their a sister forum in this format for Excel users?

Is there 2 levels of Access 2010? What is Client? How is it different? How do I know what I have?

I have a simple data base with 2 tables. One table is the pertinent Employee data. That includes a EmployeeID that I contrived myself with the first 4 letters of the FIRST NAME and the first 3 letters of the LAST NAME. I manually figured that out. Because I was new at this project. But I...

I'm missing something. When I drop a field into a form I'd like to take the Lable Box and put in into the Page Header section and leave the data field or control box in the detail field. Sometimes I have available "Remove Layout" function to split the 2 so I can manipulate them around. What...

Maybe this is a dumb question. I have a DB with 2 tables. An employee table and a work log table. Equally the same to populate them with 2 forms. The work log table is connected through the employee's ID number. But for confirmation I need to have the employees full name pop up on the work log...

My 2nd table has this error. ACCWeb107013 Error text Property value is not compatible with the Web. What it means The indicated Number field has its Format property set to something besides General Number, Percent or Standard. Only these formats are supported on the Web. What to do...

The following Code pops up when I run the "Web Compatible" check? ACCWeb107014 Error text A Table should have a Primary Key and it should be a number with field size 'long' to be compatible with the Web. What it means The indicated table has one of the following problems: · The...

I'm shopping to buy a new laptop and upgrade from A2010 to 2013. But I read that the 64 bit version may have some problems. Is it then a critical decision if the computer is 32 bit or 64 bit?

How can I prevent my staff from entering an un-bound control box calculation?

I have 3 conditions that must be met on a form before a record should be saved. I have a "Yes/No" field in a bound button. Condition 1) must equal 24. 2) can't exceed 14 3) can't exceed 100. Then if it's a "Yes" ( it needs to input a "yes" in the control or field), and then "open a new...

When I tab to this button I'd like the border to change color so the typist knows where her focus is for sure. I've tried numerous syntax to no avail. Why doesn't this one work? =[RecOK_Label].[BorderColor]="#22B14C"

Private Sub Driving_Change() Me.Recalc End Sub Why will this not accept a number with a decimal place like 6.5? It used to.

Is it possible to have a 2 step confirmation process. I have a yes/no control box to confirm that the record is OK or correct. Is it possible to have a second process where by I can lock the record from erroneous data entry or editing? Like a "Post" in accounting.