Search results

Thanks!! That did the trick.

I have a db with a field that I need to split and put values into two other fields. The format of field1 is either a-b, aa-b, aa-bb, or a-bb. I want to take the value before the "-" and put it into field2 and then take the value after the "-" and put it into field3 and then delete field1. Is...

Thanks, guys, worked like a charm. Just had a brain freeze. Tom

In a report footer I would like to sum on two different fields and then combine those sums. Here is what I have done: Field1: =Sum([Documents]) e.g 25 Field2: =Sum([Pages]) e.g. 125 Then I want to do a Field3 which is the sum of Documents + Pages e.g. 150. I can't quite get the syntax...

Oh, Yeah, When I have tried to make a table of the updates tblUpdates and then to delete that table for the move table I get the message "Cannot delete from specified tables". The move table is just a straight data entry table, nothing fancy. tom

I have a master table of folders, tblFolders. Then I have an input table where users enter new location info when folders move. It isn't practical to call up individual folders and then change 4 fields, so they input to the move table. I then update the master table from the move table based...

Thanks, Pat, I wanted to stay away from parameters if possible. As it is, the user will need to search on the input date field to reset the print flag if something such as a printer jam occurs. Also, a user may enter new records thoughout the day but may only print two or three times per day...

A little more explanation A user can enter data first thing in the day and then enter more later in the morning, etc., and print mid-day. Then they can enter more in the pm and print at the end of the day. I have set the label query to only select the records with the checkbox checked and...

I have a form where users enter information into a table and then print labels for what they have entered. They need to be able to choose which records to print labels for. To do that I have put a checkbox on the form to say print a label. After the label prints I run an update query to...

I have a records database where a user can enter descriptive information for a file and then print out a folder label with that info. All of the descriptive info is retained in the folder table but I want them to be able to print out labels for selected files. I already do that with a...

Thanks, I'll give that a try.

I am in the process of combining several different databases but need a unique number to identify each record for label printing, etc. It seems that when I append a table to an existing one the autonumber field repeats itself. In other words there are two records with an autonumber field value...

I have a form with several cascading combo boxes. The data for each combo box comes from a query that writes to a table called rowsourceX. Access automatically gives a warning about pasting new records into rowsourceX. I have used the following code to turn off the warning: Private Sub...

The search form has all unbound controls, the results fields all have control sources.

I have a database to track files. In one application the users only had runtime Access so we did a work around using two forms to search on a table, one to search and one to show the results of the search. This was downloaded from Microsoft. From this site I got great help in putting code...

Thanks, With a little modification it looks like it works. Thanks, again.

I am using a form for users to enter search criteria. They can enter criteria into any of about 20 fields on the form. A command button then displays the results in a parent form. This was not developed by me. What I want to do is to add a command button that clears the criteria from the last...

I have a client that because of privacy of information regulations can't have everybody in the company seeing file descriptions because they contain social security numbers. Other records such as those for accounting can be viewed by anyone. All of the records are in a files table...

Thanks, Tim, It looks like this is a popular problem that may have been fixed with Sp-3. I've printed the article from the knowledge base and will give it a try. Tom

My database works fine for a while and then all of a sudden I get the following error message when I try to open a form or report with any event procedure: The expression [event name] as the event property produced the following error: Error accessing file. Network connection may have been...