Search results for query: *

I am having problems in changing an access data base from MDE to a MDB. Do anyones out there know or have instructions on how to perform this task? Also once I have made my changes in the MDB data base I will need the instructions to change the MDB data base back to the MDE data base. Thanks...

I am having problems in changing an access data base from MDE to a MDB. Do anyones out there know or have instructions on how to perform this task? Also once I have made my changes in the MDB data base I will need the instructions to change the MDB data base back to the MDE data base. Thanks...

Thanks HarleyQuinn for the information. Jaggar

Can anyone help me. I have not used Access since 2003. I need to modify an export file. I cannot remember the steps to do this. I used Visual Basic to perform the process. DoCmd.TransferText acExportFixed, "ExprtSpec1", strQname,strFileNames. For ExprtSpec1 I believed I had to click on...

How do you code a variable which have dollars and cents amount in SQL to round up to the nearest dollar? Thanks...

I am trying to import records from a text file (which is located in a folder on our server) to an ACCESS database. My problem is that I have defined the specification file with delimiters between each field. The last field in the record is defined as a 'comment' with a data type memo. My...

Can any one tell me how they keep track of their updated objects? Is there a way to print out of what objects has been updated? Thanks

I do not want to form a likage with this text file to an Access table, because once I delete the records in the text file, other records will be written to it. Thanks, Jaggar

My question, how can I delete records in a text file on the server using ACCESS/Visual Basic ? Code used - when the User clicks on a button in Access the code behind: Dim strAcctFileName As String Dim fs, f, ts, S, a Const ForReading = 1, ForWriting = 2 Const TristateUseDefault = 1...

Richard, You are correct. Thanks

Thanks, Replace or overwrite please explain the differences. I also would like to know which one would be the easiler to process.

I would like to create a form in which a user can click on a buttom to restore an access table from a disk (text file). I would like the data from the disk file to overlay what is in the table. Can this be done?

I have two query. Each query records has an ID_Number, an ID_code and money amount (Sum UP). How do you compare records from both query. I am writing a report for example, I must compare the two query. Match and duplicate won't do. Query one Query two Records 1 A 200...

I created a query that calculates a percent .0200 to a budgeted amount. Percent_Incr = (.0200 * [Budgeted_Amount] + [Budgeted_Amount])what happens in the query I get the correct value without the period and the cents added even thought it has a fixed format. Then when I creates the report it is...

Is their an SQL equivalence to the Visual Basic CStr(Mynumericfield)?

I have a field called hours which is numeric (009999.0). When I create a text file, the zeros are removed and the field is left justified. How do I keep the zeros in the text file?

ORION45, Thanks for the prompt reply can you give an example??

I have a subform with a Combo Box that needs to display a years fields for a particular SSN (selected from another Combo Box). For example my table, training history, has the years 2001 - 2002 - 2003 for all SSNs. SSN 111111111 may only have a history record for 2002 and that's all I want to...

Thanks for the prompt response, evalesthy. Your suggestion worked.

I have a form with 2 combo boxes. One box presents a list of SSNs and the other a list of Last names. How do I clear a previous selection? For example, I click SSN 111111111 which returns data for that SSN. Later I click the second combo box, Last Name Smith. I want to clear the combo box...