Search results for query: *

Good morning all, I have looked in the help menu and checked the FAQ's here but cannot find any info on the fetch defaults property listed under the data tab of a forms properties. Any idea what this is or what it does? Thanks, JRS

Over the past couple of months, one of my systems which has been very stable over a long period of time has been generating a lot of errors which require a compact/repair to fix. Easy enough done in 10 secs or so - big trouble is getting everyone off. (Mettings, breaks etc) I recently found a...

Good morning, I am trying to straighten out a canned training mdb from the back end that got buggered from a lack standardization from the outset. There are 465 training records (training type) There are over 10,000 of the above in the employee training table. I have re-configured with the...

Hello again, I need to archive some old records, my only problem is that in the date field was set up as a text field and people have their initials next to the date. Any way I can run a query to still show dates prior to 12-31-2001?

Hello everyone, (I must preface this with my "I don't know how to write code or SQL" statement!) I have a form with 5 subtables that someone else developed. The Master Item Table has an auto number MasterID feild, with the others linked as child in the forms. I want to create a...

Can I make a form out of an update query? I have re-configured a canned program and am doing updates on the backend. It would be a HUGE help if I could create a form or a prompt to enter info in i/o entering date into the criteria/update to fields. Thanks , JRS

Hey ya'll. I keep getting a "MDB needs to be repaired, or this is not a database" error messages. I don't know if it is from a bad network connection on someone's pc, or if construction crews remodeling one of our buildings is causin g an interuption - or something I'm just not aware...

All access programs have been running very slow the last week on the server. At lunch today, I was going to do some upgrades, and when I got everyone off the system I was going to work on, I ran compact/repair first. It would not run, it would hang up and when I checked task manager, it showed...

Hey y'all, I don't know hoh to write code, but I was told there is a way to write code to kick everyone out of the system. There are times when I need to perform maintenance, updates modifications etc. and it seems like I am always having to chase someone down to get them logged off. Anyone...

I have a fairly large mdb (A2000)in a multi user environment. We have 2 plants with a fiber optic cable running between buildings. Last week a contractor cut the line (it was fixed immediately)Starting that day, and just about everyday since then, once per day we get the This is not a database...

Hey folks. I am working with a VERY simple form/subform for an ongoing customer survey. There are 3 categories with 12 questions each. Only one question from each category will be asked when a customer places an order. So if customer A places 12 orders in one month, it would take one month to...

Hey ya'll, I have a form for a customer survey quistionnaire. There are twelve questions relating to our company and best competitor. These are numeric fields to do a ranking of 1-5. I need to know how to have a field calculate a running average for each column of 12. Not all questions will be...

I'm trying to create a data access page (first attempt) can you insert a subform? I don't see an option to do this on the tool bar.

I have a new task given to me by my boss. He would like to have a simple form created so that when customers place an order, a customer service rep can ask a question of the day. Ex. Delivery performance, product quality etc. He would like the following 1. Store the questions in a field or...

I have a combo box which looks up records when either selected or manually keyed in. I was shown today that if you type in an item number that has already been selected (visible in the field) it goes to an entirely differant record. Example, you type in gss0110a, and you are going down a report...

Hey y'all, I have a VHS-C camcorder that has a JLIP jack. What would it take (Hardware/Software) to run video on my PC?

How do I insert a page break on a report? I have a report which will contain sub reports, I want to make this a formatted two page report. Thanks in advance! -Smack

I am working on a new system that has to do with R&D's. One part of this includes proposed standard operating conditions (SOC's) which will be using the same structure of our commercialized SOC's. When a proposed SOC is finalized, how can I send this record to the other mdb. -Smack

I'm setting up a new mdb, and I need to assign record numbers. I need to know how to format a number that will show something like RD02045,and the next new record to be RD02046 I found this from Lonnie Johnson in a thread, Or you can set the default value of this field on your form using the...

I want to create a report like Test Min Max Tensile 12 14 Elongation 23 28 Drop Dart COF .02 .023 In the example above, the customer does not require drop dart testing. How can I have the report hide the drop dart label...