Search results

I need to show two decimal places on a form based on a recordset of a table that has a field - type = double, format = fixed, and decimal number = 2 I need to show 101.00 and 102.00 so if user insert a record, record would have a sequence id of 101.05. How do I create that field by code...

got an array myarray(0,4) as variant. I want 0 to be a redimmable so I could go 0, 1 = a 0,2 = b 0,3 = c 0,4 = d redim preserve myarray(0+1, 4) how do you declare this array in the first place? isnt it supposed to be an empty parentheses -- () in declaration.

I have a million record of a single field that has combination of funny characters and letters in it. I only want to pick out the Uppercase data. I dont want to turn them into UCASE. For example: {sectl}SECTION I<qa>\nPREFLIGHT (05-20-10)\ I only want 'SECTION I PREFLIGHT" Any ideas...

I can create multiple primary keys for a table MANUALLY (by highlighting several field then pressing the key icon) BUT I cant recreate it by code. HELP. Set NewFld = tdfnew.CreateField("TaskID", dbLong) Set idxNew = tdfnew.CreateIndex("TaskIDIndex")...

I am trying to reuse a procedure for different tablenames my procedure is like this. _______________ dim rst as dao.recordset set rst = db.openrecordset("table1") rst ("AFieldnameinTable1") = 1 _______________ IF: rst ("AFieldnameinTable1") = 1 I want to replace...

Has anyone tried using MS ACCESS with Advantage database server?

MDE, Corrupt Database, Front End, Back End, Never Ending Problem/ CALLING PAT HARTMAN I have a database that both have a back and front end. I may not know what I am doing so please bear with me if you think I am a bit ignorant. I made my front end database an MDE so users won't alter the...

I have a front end and back end database. The form is in the front end and the table is in the backend database. The field is of memo type. When I enter data using the table, everything is fine. When I enter it through the form however, it is truncated. Help.

I have created a label report of names, address of records that True value for field called MailThis(?). After I print this label report I would update the boolean field called FinishPrint. Which event do I put the code for the update? I could create a message box after deactivating the...

I am creating a log of edited records. So let's say I have two fields: NAME, AGE Say my present Record is NAME- Liv Manto AGE- 28 If a user say, User 8 change the record to: NAME - Olivia Gonzales AGE - 32 I will a add a record to a log table EDIT: User08;Name-Liv Manto:Olivia...

I need to move my msgbox at the lower left hand corner of the screen. How do you set a msgbox's top and left position?

CONTROL'S VALUE IN AN ARRAY - HELP My objective is to copy all the values from one record (from a form) to another new record. I am thinking of using the For each ctl.. Next Ctl. First I would create an array with upperbound of the number of textbox controls. then For each control, I would...

I have a button for a new record dim x as string me.name = x docmd addnew x=me.name I however have 19 data to copy, different types. Anything else easier and shorter? I have to do it in 20 forms, different data.

When I format a text in a memo field (Bold, underline), it formats all the text in it.

I used the AppendDeleteField command to add new field to an existing table. It wouldn't let me. It's asking for a reference. Which one should I check? Any other command to add new field?

How do I put the record number in an unbound text box. I am simulating the navigation control but I don't want to use it.