Search results

Can any one tell me how to force right justification on a text field in a table? I need to generate a txt file from the table, and I need to be able to control the justification on all the fields. It is easy enough to change the justification on a number field using "!" in the format, is there...

thanks that seems to work but why does access insist on adding slashes to the dates at export, even when they are not in the originol table? Not Nice. Thanks again

I need to export a table to a text file ....this is all working fine except for the fact that the dates need to be in yyyymmdd format with no slashes. I have my TABLE set so it does not show slashes, but when I export the table to the TEXT FILE the slashes appear in the text file. I have...

Yes the code above is at the top but still no luck p

I have a switchboard form that opens other forms. When a form is opened using the switchboard, and then closed, the comand button on the switchboard will not work again until a different comand button has been used. Then it will work again. confusing enough? how can I make the button reset so...

does anyone know how to offer a good exit from a form. My form automatically populates two controls DATE and Employee #. I want to have a way so that the user can exit the form without creating a record related to the two auto-filled controls. A way to cancell saving the record perhaps.. thanks

I got it working by setting the criteria in the append and delete queries to only take record entries higher than my dummy entry... It Works..

I need to modify a delete query so that it will leave the first record in a table intact. The problen is this... I have a two table "archiving" system that uses an append query(to add data to "archive") followed by a delete query(to remove data from "temp"). I need to leave 1 "dummy" record in...

This is a rather complicated thing to explain but I will try. I have a database that has two main tables... one table is to hold data temporarily "untill it is doouble checked" the other table is for the "permanent storage of the data. I use an append query to move the data. The form I use to...

It's OK I've figured it out...Had to change the Query to Select Top 1 in the SQL view. seems to work. thanks for the help. This forum is very useful! p

The dynaset I have is working except that it returns multiple records. I just want a way to select only the top record...Should this not be easy? please pardon my ignorance. thanks again p.

I am trying to make a query that will extract the most recent record entered into a table. I have three fields in my query: RecordID (autonumber primary key of table) Employee Number Date the query works but gives me multiple records in the dynaset...I only want one record. I need to know...

The problem with checking the fields at the end of the proccess is that I have two list boxes whose contents are determined by the re -query of a combo box. In order to keep these list boxes up to date I used the Me!Refresh method. If users start entering data out of sequence the required(date)...

disabling the other controls works for the first time the form is used...but after it seem s that the controls remain enabled what should I do. I tried setting it up so that the controls are disabled On Open of the form but it still does not work.

I have a rather lengthy form for which I would like to be able to control the order in which the fields(controls) are filled in. How can I force the user to enter data into the 1st control before moving on to the 2nd control and so on? I also would like to generate appropriate error messages...