Recent content by bojbrown

Hopefully someone has some insight to this. We need to convert an Access 2000 database application to VB.Net. While we can convert the DB to SQL Server, and to MSDE too I assume, we are concerned about converting all the forms to VB.net? We can convert to Access 2003 as an interim step if...

This should be a simple task, but I have yet to figure this out. In a form, you the FIND command or the Find button will allow a user to enter the criteria for a specific field and the form will display, or jump, to that record if they are using the primary key field. But how do you allow a...

Thank you for the reply, but I know how to use dlookup and can use this command to determine if the record exists. But the problem, especially in a form, is making a specific record the current and active record in a form based on a user's input. All commands to do this seem to revolve around...

I have a table with a primary key made up of 2 fields: A user's ID and a date. I know how to find a specific record with only one field, but there doesn't seem to be any command in Access to go to a specific record with a compound primary key, especially when you are trying to display a...

RichO, This works, but how? Does Access automataically build an array of fields? I would have never thought to use any command with ME without the period after it. Thanks for the help.

Thank you...I will try it.

I have to create a form for creating schedules for individuals for a client who was very specific about what they wanted. One form that breaks down 24 hours into 15 minute increments and color codes the times (I know...Outlook has a scheduler, but we won't go there). I have the form and the...

Thank You very much.

I have tried that, but each record displays the total of the first. For example, if the customer has 2 invoices, and the amounts are: Due Paid WO Bal Due 100 0 0 100 200 0 0 100 the results of the first record/row are displayed in every row...

I have come across a problem that is causing Access 2000 to lock up! I have a form that displays invoices for a customer in a subform. Each record/row in the subform displays the invoice #, date, total due, total paid and total write-off. This works without a problem and displays all invoices...

I have a report that does not print a detail section, but prints 2 group footers. My report summarizes all transactions for a customer, categorizes them and then prints the Customer group footer. The second group is by date. So it will summarize all customer transactions and then print a row...

I have added an unbound text box and have given it a name 'XAmt'. In one of the footer sections, I have another unbound box with a control source of =SUM([XAmt]), which follows many of the examples I have seen. XAmt has a control source of =IIF([TXN_AMT] = 5,[TXN_AMT],0) and TXN_AMT is a field...

That is correct. It is processing once for each row. That is not the problem. The first customer has 3 detail transactions, thus 3 rows and it should run the detail section 3 times....it doesn't...it processes 9 times.

Thank you Pat, I will take a look at the Retreat event. The data cannot be summarized. Each transaction contains only one amount along with its accounting category, so processing each row is OK, becuase each row is checked for its category and added into the appropriate column, but as I...

Update to what is happening for "Serious Reporting Flaw???" I have an update to what is happening in the report: I the FormatCount property stays at 1, however, the transactions themselves are repeating. For example: for the first customer there are 3 txns for $10, $21, and $25. The detail...