Search results

I am tryng to take the records from one table and insert them into another using a recordset and Docmd.RunSQL "INSERT..." I don't want the "You are about to insert 1 row..." so I can use Docmd.SetWarnings False but I DO need to know if the record won't insert due to violating the unique key on...

How can I ensure that my user enters a value that would be valid currency? For example, I would accept 1 or 1.2 or 1.23 but not 1.234. If I set the textbox format to Currency, it shows 1.234 as $1.23 but the .text is still 1.234. Thank you!

Is it possible to change a field name in a table via code?

I have added a TreeView to my form. When I try Me.TreeView. to get the available options, some items that I know work do not appear, such as .Nodes Anybody know why this mught be?

I added a button to my form via the wizard. When I got to the end and clicked Finish, I got a "Subscript out of range" error. I was forced to cancel out of the wizard. Now when I try to use the wizard I get the same thing. No big deal you say. Don't use the wizard you say. Well, If I...

How can I either prevent or trap when someone is trying to delete a record using my form by clicking Edit/Delete Record or the red >X on the toolbar? I don't want users deleting records!! Thanks!

I have data that looks like this: Acct Status Date 1 A 1/1/2001 1 I 1/2/2002 1 A 2/3/2002 2 A 4/1/2002 2 I 4/5/2002 3 A 1/1/2002 I need a query that will return the current status, meaning the status with the most...

How can I tell when my user is at the last record for a bound form so they don't move to the Add Record blank record that is associated with the >* button?

I have a passthru query to an oracle table that is supposed to return the sum of a field with a format of Number(11,2). It holds currency values, but when I get the return, it is rounded ot the nearest dollar. My SQL is: SELECT sum(charge_cr_amt) as TotalUsage FROM...

I have some code that opens a recordset and I want to perform tasks based on the data in the current record. For example, if the field [CrCls] = A, I want to pass the entire record to the function named CClassA. How can I pass the current record to that function?

Does anyone know how to parse a record from recordset so I can write it to a file? I want to be able to write out all of the record, but I'd like this to be flexible enough to use it for ANY recordset, and not have to code the field names. Thanks.

I have a Hex value (will be like "FEFF4CD8") I need to convert to Decimal, but I do not know how... Anyone have any pointers? Thanks!

I have a user that needs to send e-mails via VBA in Access. They don't want the e-mail to appear to come from them, however. They have another e-mail box (Outlook98 on Excahnge) that they can put in the FROM box, and it then comes from that mailbox. How can I do the same via Access VBA...

I have a table that looks like this: Item Parent 1 0 2 0 3 0 4 3 5 3 6 5 7 3 8 0 I want to be able to do the following: Delete a record and any records that would be under it. For example, if I delete Item 3, I need to delete items 4, 5, & 7 because their Parent is 3. In addition, Item 6...