Recent content by genaccess

I mean, when I try to import and point to the corrupted database, Access gives me the same error (3197) as it does when I try to open it normally. I do not even get to the objects screen.

Hi Dhookom, Thanks for your reply. I tried importing objects from the frontend to a blank database. It would not let me do that. The same error pops up. I also tried using demo versions of various access recovery software available online, one was successfull in recovering (as the report...

Hello All- I am facing a serious error in one of my databases. It is an invoicing database split into frontend and backend. When I try to open the database (frontend) it gives me this error " The Microsoft Jet database engine stopped the process because you and another user are attempting to...

I am assuming what you want is an audit trail. You can find many threads on Audit Trail. Use the search feature of this form and you will find FAQ's and threads full of VBA codes that you can implement in your database

After update event of combobox use Select Case Me.Name of the combobox Case "OptionA" Do Noting Case "OptionB" Msgbox "Remember to notate...." End Select You can also use IF statement

This is what I have. I remember finding this code on some website. I slightly modified to meet my needs. You will need a table with username and password stored and a form with username and paswword textboxes plus a command button. I placed this code on the click event of the command button...

Hi, Did you use the right switchboard command? You should have Go To Switchboard and then point the sub switchboard you want to go. Genacess

Hi, I have a subreport within main report. For some reasons when I open the main report it does not display the labels in the subreport. I have the subreport in the detail section of the main report. Can any one help? Thanks in advance

Did you set password for MS Access. I mean for the admin. Check that out!

Make a form with text box taking date as the parameter/ or you can have a calender control.....(to be smart)...Build a query that takes this date as the parameter and create a report based on this query... I think that should be it.. GA

If I have understood your question... If you require only the number of records you entered today, you can build a query with count as the function and Date() (Today's date as parameter). and requery this query on the opening of the form.You can have a text box that displays the number. GA

I have a database where I input daily readings for particular product inventory. My products are fixed, but daily readings change. So I made my products as different fields. Now I want user to specify the product (Product is a field) in a combobox and it should display list of daily readings...

Set a new combobox with the values you want.In the query, set the criteria of the field you select in the combobox as =Forms!Combobox. Design a macro which requery's your list box. Put a command button that runs this macro. That should do it. Let me know if you need detial info. am in a hurry...

I have a combo-box(unbound) on my form which gets the values to look for from its inbuilt query. The values are the product numbers(integer/long integer). The problem is it displays 2 decimals.I specified into properties the format to be fixed and decimal to 0 places.It does not save. I also...

Mas5, I have used those techniques...Actually what I am looking for is different from that...That is an entire toolbar which has inbuilt navigation buttons and all we do is specify the location of the data table and the buttons start working themselves...Its really a neat tool. -Chirag