Search results

Hi all, I'm using a popup form to enter new data into a table (tbl_Applications). I am passing an ID (apartmentId) via OpenArgs which needs to be stored in a non-primary field in tbl_Applications. I'm using the acNewRec parameter to go automatically to a new record. The problem is that I need...

Been hunting for the answer and I thought I had the solution at one point but I could not get any output. Any help would be highly appreciated. I have three tables: tbl_Users tbl_Rights tbl_Users_Rights I need to select rightId and right_name from tbl_Rights where there are no entries in...

I have a report which has five sub-reports. If a sub-report contains no data I would like to display a freindly message like "No completed records today." or something like that. Unfortunately the On No Data event doesn't seem to trigger for sub-reports. Has anyone found a good way to handle this?

I'd like to export my reports and preserve the formatting (i.e., fonts, colors, etc.) without using .SNP files. I would ideally like to export to HTML and create the template with formatting based on field names, etc. But from what I can see HTML templates used by Access only recognize a few...

I'm using a query to return negative currency values, and I need to convert them to positive values and include them in a string. This code works fine except it strips all trailing zeros: CCur(Abs(rs("trns_amount"))) I.E. -$123.90 would be returned as $123.9. Is there a way to preserve the...

Reading through chapter six of Microsoft Access 2000: Building Applications with Forms and Reports it explains that the forward-only type Recordset object is usually the fastest method. I assume that a table-type recordset would be somewhat faster, but like most of us I am using linked tables...

Hi all, I'm trying to open a form with the OpenForm method using multiple values in a criteria field. Basically, during data entry in my chargebacks DB, the DB checks the case number they enter for duplicates and if it finds duplicates I would like to open these duplicate cases in my case...

I'm having a real tough time with this query I'm trying to create. I need to retreive transactions which are not related to a specific chargeback, but are related to a specific credit card number. tbl_Transactions stores all of the transactions. Each transaction record has an orderId with a...

I'm trying to set a report's filter property to the filter used by the parent report. Is this possible? I would ideally like to say: Me.subReportName.Report.Filter = Me.Filter Or somethign along those lines. I'm setting the filter property of the parent report from a form; the user selects a...

Hiya all, Been playing around with ways to to apply colors to my command buttons, as well as use GIF's as a command button image. I came up with a really simple solution using the MouseDown and MouseUp events to make a realistic looking command button out of a box and an image. Just thought...

Is it possible to use a public function from within a private form sub? I am trying to pass a value to the function, and assign the return value to a variable. The function is defined as such in a module: Public Function cbStatus(chargebackId As Integer) As Integer ' Determine the current...

Hi all, I'm trying to get an updateable recordset using a complex query involving many joins, but I'm running into some problems. I'll explain what the database is for and a bit about how it is designed to give you an idea of what's going on. I would appreciate any help with this :) The...

Hi all, I have a continuous subform which shows a record of transactions related to a chargeback in a database I am building. It's working perfectly aside from one thing. The top and left side of one of the fields in the transaction list will always reveal about 2px of the background color. If...

Hi all, I hope this belongs here instead of the forms forum. I am nearing completion of a chargeback database I have created in Access 2000. The database has ~100,000 records in the orders table and ~100,000 records in the transactions table. Both of these figures will most likely balloon to...

It seems that whenever I use a continuous form there is always one entry with empty controls at the end. Is there a way to get rid of this line?

I'm relatively new to VBA, and Access in general. I recently designed a DB for entering, processing and analysing chargebacks on our companies merchant account. I have a basic search form which uses a continuous subform to display results, with a detail button to pull up the record. It works...