Search results

Sorry, my fault, server1 should be the field name. So, using your data it will look like this: Field 1: [Sheets] Field 2: Expr1: Val([Sheets]) Field 3: Expr2: Right([Sheets],1) In your query, if you are using just tableQuestion in design mode, you will not need to qualify the field...

You can use the OutPutTo command for the table. It can be exported to different formats, including Excel.

How are new records created when the user has multiple records to enter? If they are able to go to the second tab, without going to the table header, this may be part of the problem. You may have to set up a new button that clears all the fields and forces the user to the first tab.

The casenum 0 may have been created if someone cancelled before entering all the data. You may try deleting it, but not before you backed up your data. Also, you probably did this, but you want to enforce data integrity on your relationships with tableheader.

Rhonda, I built a query that has 3 fields the first field is your number i.e (1.1a, 1.1b). Lets call this FIELD1. This will be from the table that has the field. I created a second field and looks like this: Expr1: Val([FIELD1]) Sort this ascending. I also created the third field and it...

A process server delivers court documents i.e. subpoenas, affadavits, etc..

Tables to start with Business Table Your Business Nam Adresss, etc.. (Can print on Invoice) Customer Table Customer Name (Key) Customer Address City State Customer Skip Charge (Used as default when customer is selected) Customer Court Charge...

Thanks Pat. I got something from this as well. I knew about what caused it, but your solution was right on.

bradcccs is correct. You can create an update query that updates type to Customer where customerid = customer name or, since you are familiar with recordsets, Set rst = CurrentDb.OpenRecordset("customers", dbOpenDynaset) With rst .findfirst("customerid " = customerid) if not .nomatch...

Unfortunately, the record/s are corrupted. The only thing to do is to delete the records and you will probably loose whatever data was there. You may not be able to delete the record until you run a compact and repair on the backend database. This problem can happen if two people update the...

Is the listbox in multi-select mode, where the user can highlight more than one item on the list. If not, and they can only select one item on the list, you can add a criteria in the query that the form is based upon. What you have to be able to do though is provide the user the ability to...

I distributed an MDE and no errors come up when starting the program. I also had them run the MDAC executable, but that still did not fix the problem.

If by nested, you mean have queries based on other queries, the answer is Yes.

Yes, Queries can be based on other queries. Instead of making a table with Query1, make query 2 based on query 1. In design view when you first design query2, you will have a tab with Table, Query, Both. Choose the Queries Tab and find Query1. Base your Query on this. If you still need...

This may be some type of linking problem between the report and subreport.

I believe Neileg (hacker or not) is on the right track. You'll probably need a couple of queries. The first query (query1) will be a select query that will have one little twist. Go into it and pull it up the SQL code. After the word Select, type Distinct. SELECT DISTINCT Table1.Server...

Like Rich said, its in the sample folder. I also believe you can download from Microsoft.

I hear you, but just like you used a subform to total on the form side, you can use the sub report on the report side. Also, you can use the =sum[Fields] as the control source for your total field.

OK, work with me here. There is a way to do this, but requires some work, but if this is something done quite often and there are a lot of fields you can try. 1. On the Main form that has the fields you want copied, create an export button that brings up a pop up form. The pop up form will...

The rule I try to use for fields is if I can create a total or value, don't store the value. If you need a total, use a sub form to add values. As the users enter values on the subform, you can have a field on the main form display totals. The Northwind Sample Database has a good example of...