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

When the user logs in you want to record their userId and any other info you will be regularly using to either a table, a hidden form, or a public variable. I use a hidden form to store my user details. You can create a form with unbound controls for each of the user values you want available...

Apparently Access is trying to lock the new table that is being generated but the open report is using it. Will opening two of these reports at the same time be a requirement of the project? Maybe you should share the code being used to generate the table.

If you have the properties screen open when you save and close the DB it will show up when opened again. I haven't investigated it too deeply, but I've noticed this happening too.

I found a way to get the results I needed by performing a simpler query and then filtering the results. Since I need to assign the results to a listbox I also had to use ADODB and the GetString method to extrapolate the proper string format to apply to a rowsource. It's probably not the most...

Hi DuganTrain, thanks for the reply. This only returns records from tbl_Rights where there is no matching record in tbl_Users_Rights though. I need all records from tbl_Rights where there is no matching record in tbl_Users_Rights with a specified userId. The Users_Rights table stores pairs of...

Assuming your Bowler Details form is based on the bowler ID, you can use the OpenForm method with the criteria set to the ID of the specific bowler you want to view the details of. Create a command button with the following onClick code: DoCmd.OpenForm "Bowler Details", , , [Bowler ID] =...

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

Pat, I'm using forward-only now when I'm just retreiving one or a few records.

Thanks, my search wasn't getting me far before. I found a pretty good solution, although using HasData I could probably create a generic "no data" report and swap the subreport with a different one at generation time. This is all a guess though -- for now this works...

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

Got it! Format(Abs(rs("trns_amount")), "##,##0.00")

You're right CCur is unnecessary. I tried it thinking it might convert the number into a currency format with the trailing zero's. (To no avail).

Very cool, thanks for the info.

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

Hi dcx693, I aprreciate the clarification. Also I apologize for not getting back sooner, I'm far too busy as always :o In your final comment, do you mean I can open a linked table as a table-type recordset if they are in .MDB? Thanks!

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

Okay, I got it. The criteria format was fine, but the associated records I was testing did not have enough data populated to open in the case details view. Now I tested with a few other cases I knew were true duplicates and it's working fine. :)

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