Recent content by usfpjc

“Dynamic fields”? Rather than listing fixed fields in a form, I want to have them appear as needed by using the “dynamic” field approach. Reason: I need to create a Job Status tracking system, where I need the following fields: Employee Name, Rate of Pay, Date Worked, Hours Worked. If for...

I am working on a new form and when testing the selected fields, I go to the Tab order (Design Mode) and select "auto order". Usually it works fine, but in this instance I am noticing "text (labels?)" listed in the sequence of fields. When testing the sequence, I notice that I have to tab twice...

I have created a worksheet where some cell rows have informational text and need to be restricted from entering additional data. I want to protect that specific area by disabling it - ("read only"). How do I do it, without disabling the entire worksheet?

I have created a query to be utilized to create a particular report. The query points to a particular drop down field in a table, for selection of Quarters 1,2,3 and 4. In order to trigger the report that only selects a particular quarter of the year, I need to put something ( a statement) in...

I am trying to define a constact factor field in a table, let's say: Field Size: Long Integer Decimal Places: 4 Input Mask: 9.9999 Default value: "8.3536" When I build a query, and choose that field from the table, I do not see the constant value as 8.3536, but only 8.0000. What happened to...

I have created in a table a Field 1= "drop down" field, and two additional fields, each with a distinct constant. Field 2 = Constant Y Field 3 = Constant Z I want to assign the correct constant when I choose a particular item from the drop down field. Example: Drop down field has two choices...

For some reason, or something thatI did and do not recall what was it, every time I start my system (Windows XP Professional), the icons that I had deleted previously, tend to replicate themselves more than one time, filling my desktop screen "to the hilt". Is there something I can do to...

I forgot a "trick" I had to copy an image from a file, and place it in the "Paint" program. Example: Let's say that I am looking on my PC screen an Excel data sheet. I want to capture the image exactly as I see it on the screen. What method do I have to apply in order to copy the image...

Trying to enter data in field that accepts 1 or 0, the record is not "locked" by other "user", because the only user that is doing the data entry is "lonesome me". Any ideas? jc Field cannot be updated. (Error 3164) Possible causes: You tried to update a field in a record or table that is...

I have created a form with tabs that open to tabs 2 through 5. These tabs contain sub-forms. My problem is, that when I finish entering the data in the last field of form 2, instead of opening tab 3, it goes directly to tab 4. Of course, I can click on tab 3, and make it happen, but I would...

I am trying to create a mask to enter a credit card number. For example: 1224 3456 5678 1234 I want to force a blank after the first,second and third group of numbers. I tried the following mask: 9999&9999&9999&9999 After I enter the first group, it does not skip with a blank to...

I have an Access Data Base that has been updated with another table. The new table contains two new fields that I want to import to the main table. I have tried with an "append query", but the fields wind up at the end of the table, and not positioned with the records to which they...

Created a Data Base, and I want to protect the form by not allowing anybody else from changing the code in design mode. Any ideas?

Let's say that I would like to find records that fall between for example between 01/01/01 and 03/30/01 using a query, what type of technique should I use by typing in the query criteria section some type or argument. Example: [Type date ranges:] between xx/xx/xx and xx/xx/xx I tried this way...

My printer spooler is printing the same document over and over. I have Windows XP professional installed, and the OS does not permit me erasing the printing job from the job queu. Do I need a patch to fix this problem?