Search results

If you have a table with 100 records and you delete all the records, you can compact the db TWICE and your autonumber field will start over at 1. If you leave records in the table, though I know of no way to force the autonumber field to pick one that isn't being used as opposed to picking the...

I KNOW there is an easier way to do this, but off the top of my head, instead of sending my SSN field to the word document, I would send an unbound text box with the value: left([ssn],3) & "-" & mid([ssn],4,2) & "-" & right([ssn],4) That gives you the first three numbers, a dash, the middle...

You could do this a couple of ways. The best way I have found is to create a table with the form name in one field and the menu item number in another field. Then your code sets a variable to your form name based on what the value of the list box is. Dim formname as string formname =...

I am hitting an Access 97 db with a VB Executable that basically archives old data from a couple of tables which are linked. It pulls out records older than 10 days, copies them to another database, and then deletes them. It's fairly straight forward. This executable is started via a batch...

I have a calculated field on a form. I have set the format to fixed with a decimal places setting of 8. However, when I go into the field in form view, it is displaying all of the digits after the decimal. I do NOT want it to round. Is there a way to truncate in Access?

Thanks guys! It is wonderful to know that this stuff doesn't just go away. I used the first reply that I got back when I first posted this and it worked wonderfully. However, I can ALWAYS use microsoft articles and SQL statements. This forum is such a wealth of information. I'm so glad I...

I have several sub-reports. Each one has one grouping with a header and a footer. At the open of each report, I make the header visible and the footer invisible using groupheader0.visible = true and groupheader0.visible = false. In the On No Data property, I turn off the header and turn on...

Thanks, Carol. We have the Snapshot viewer here. I was hoping to avoid using that since the people who receive the reports vary from day-to-day and I have no real way of making sure that they have or install the Snapshot viewer correctly. Anyway, thanks for helping.

I have an extremely calculation intensive report. It uses a lot of Dcounts, dsum, sum and avg functions. When we print or preview the report in Access, the calculations are correct. However, if we publish the report to MS Word from the Print Preview screen, the numbers are all different in...

This works unless the user enters zeros after the decimal. If the user enters 100.25 it works, but if she enters 100.00, it drops the decimal and the two zeros before checking. I had to convert the field to a string by setting a variable equal to str([fieldname]) so that I didn't get a data...

I thought about that, but wasn't sure it would work since the format of the field is currency and it always has the decimal. I'll try it. Thanks!

I have users that requested to not have to input the decimal into currency fields. For example, to input $34.25, they want to simply type 3425. I did this by dividing the amount in the field by 100 in the after update property. NOW they want to also be able to input the decimal. SO if a user...

DUH...I figured it out. App1.docmd.quit then set app1 = nothing does the trick. Thanks for responding, Jiri! Roni

Jiri, I think I know what the problem is, but can't seem to get around it. The database that I am opening and attempting to close has been set up to not allow the user to close using the 'x' button. There is a login form and they can click on an "Exit Database" button without logging in, but...

No one has any ideas??

I have dimmed app1 as a New Access Application. I open app1 usint app1.opencurrentdatabase [field in a table] (I am using a recordset and looping through). When I am finished doing what I want to do (automated, not user interfaced) in the database, I want to close both it AND the instance of...

I was afraid of that. Not a biggie, I just wondered if it was a bug others have seen. Thanks! Roni PS - I convinced my users that queuing is a good idea - voila - no more record locking problems!

I have a button on a form that launches several lines of code when clicked. At one point, I was getting errors so I put in a breakpoint. I have since resolved the issue and removed the breakpoint. However, the code is still breaking there. If you click the run button, it continues with no...

Will this also work with form, query, report and module defs? I thought about this, but I didn't see some of the other definitions in the list. Thanks for your help! Roni

I know you are at your wits end and don't want our humor, but this struck me as hilareous and SOOOOO true when it comes to users. We are constantly bombarded with requests to save users from their own <insert derogatory word of your choice here>. Thanks for the laugh...