Search results

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

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

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

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

I have a problem that Microsoft acknowledges as a bug, especially in print preview, but I can’t seem to find a workaround. I have to produce a report that summarizes all transactions for a customer/day. The data is coming from a query. The data must be summarized for each customer, dividing...