Search results

We are having an irritating problem. Occasionally, references in Access 2k dbs go missing. We have no idea what is causing it, but it's incredibly annoying. In particular, we seem to lose the dao and ado references OR they get switched in the list and then we get weird errors in our VBA...

I need the ability to go out to DOS and run a program from a vb application. I will also need to send multiple keystrokes after the program begins running until I finally send the exit command. I am very familiar with doing similar things with a Rumba Object X control, but can't find anything...

I have an autonumber field which increments by one set as a unique key id. Nightly, I strip off records by input date and store them in an archive. I DO NOT want the key id associated with those records to EVER be used again. However, I discovered that the old 'compact twice and it starts...

I have used VB multiple times to copy data from a mainframe session to an Access table using Rumba Object X. I want to do something similar with a delimited text file. Can someone point me in a good direction regarding how to open the file in VB and how to reference the columns and rows? I...

I am using Rumba Object X in a VB executable to hit an Access 97 db. We have a mainframe based loan system from wence we basically copy information into the various fields in the database. The problem is that when multiple users are performing the function of 'scraping' the data from the...

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?

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...

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...

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...

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 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...

I have a form that will have multiple users. It opens to the first record in the query. If someone is currently using that record (not necessarily making changes, but has that record open) I want the form to move to the next record. I think my code should look something like: dim db as...

I have created code that will export an object from the current db to another db using the docmd.copyobject command (TO db name is input by the user). I want to check the other db to ensure that the object does not currently exist before I export it. If it does exist, I want to delete it from...

I have a sub report which contains two fields - a calculated field and the same calculated field that is set as a running sum over group. These fields are in a group header, not the detail section. The sub report is working fine and displaying exactly what I want. The problem is that the main...

I have a field on a report that is a running sum over group. I have discovered that when the lines on the report extend to more than one page, the running sum is SOMETIMES incorrect. Sometimes, it does not add the last record. Has anyone else had this problem and is there a work around?

I have a form that has a picklist which is pre-filled based on user login upon open. I want the data on the form filtered by that field. If the user chooses another entry from the pick list, I want the form to requery and filter by the new value. I have put the following code into my On...

I have a report that is broken into a couple of sections. In the properties of the last section, I have it set to go to a new page after the section. This works fine except that I get a blank page at the end of my report. How do I keep my report looking the same as it does not, but not...

I have a form that is split into tabs to look like index cards. I want to reference a control on that form for a calculation. However, I don't know the syntax. If I create an unbound box and set it's data property to: =[forms]![frmName]![fieldname] I get #Name in the unbound box. I have...

I have a table that the user wants 'broken up'. They want to display different data on different forms to make it easier to input. I have created a main form using the index card style tabs. On each tab I have put a subform which contains the data they want to see grouped together. How can I...