Search results

Bob, I cannot tell you how happy I am! Thank you!:D That was the problem. It’s fixed now

I fixed the hide access window error. Private Sub Form_Load() Me.Visible = True DoEvents Call fSetAccessWindow(SW_HIDE) End Sub But my error handling is still not working correctly. For example if a user clicks the navigation button past the last record; they should receive a prompt telling...

I have searched every nook and cranny and found no solutions for this problem… My database hides the access window so it resembles a standalone application. I’m not sure if someone screwed with something, but today I noticed an error while opening the database. Error #: 2475 You entered an...

I was trying to minimize null values. I won’t always know the given calories for a recipe. I do agree with the time and instructions tables. I will combine these with the recipe table. taking a second look, i would agree almost all recipes will have instructions and time values:rolleyes: I...

Hello, I’m just asking for some opinions on my recipe data modal. Besides programming, cooking nice meals has always been a big obsession of mine. I’m thinking about creating a recipe database. This is just a rough draft and I’m always open to suggestions. Let me know what you think

I’m in the same boat lol. Since my new database is multi-user I have no way of controlling the paper size. I need a specific report to always use 8 ½ by 14 paper. Anyone find a solution to this problem? Yea, I know this is an old thread. I'll continue to look and if I find something I'll post...

Thank you for the reply :-) The reason I wanted to switch the front end over to vb.net is for the experience that I could add to my portfolio. I always ran into minor issues with VBA. The syntax is a little different on Access 2003 than vb.net 2003/05 which is what I learned in school and use...

I have a wonderful database I designed almost 2 years ago. Other than a few hiccups with corrupted data, my employer is 100% satisfied with it. I’m graduating this winter with an AS in computer programming and I would like to update the database to a VB/ADO .NET (VS 2003) front end before I...

Sorry for my late response. I tried that, both ways. Same problem with listbox highlighting blank rows after the furnace is deleted. I found a fix which I’m about 90% finished coding. When a user clicks the delete button. I run a query which gives me a count for the furnace name in the record...

I created a multi-select listbox which I populate with “distinct” furnace names that have been entered into an inspection table. The end user has the option to delete records from the inspection table. The listbox gives the end user the option to filter results on a sub-form, nothing more. When...

Thanks, I set a per shift backup policy in place. I’m going to take a look at your backup utility now. Much Thanks, Chad

Then I don’t learn how to fix the problem myself… Oldsoftboss, Nothing worked. I tried importing the tables to a new database, compact & repair. I ended up making a trip to my old database mgt professor’s home and we got 99% of it restored. I think we ended up only losing @ 24hrs of data.

I wish i had that option. I take it there is no easy solution. How good are the “Access Repair” tools such as Advanced Access Repair 1.2? Has anyone tried them before? P.S. I have a backup (almost 2 weeks old). So were talking @ 600 lost records. I would like to restore the database and save...

Our quality dept had a glitch with the LCD monitor while entering records. From the email I received the LCD screen went black so they abruptly pushed in the PC power button. Now I get a “disk or network error” when I try to open the database. If I attempt to copy the database file to a new...

Hello bob :) Sorry for the late response I have five fields, 4 are general numbers and one is a medium time.

anyone have an idea?:(

The report is based on a query with a left outer join. So some fields in the report remain blank (no data).. I would like these fields to have a "N/a" defualt value.

How do you set a blank field in a report to "N/A" or just 0? I have tried Nz([YourField],0) and iif IsNull([YourField],0,[YourField]).

It worked like a charm! :D Sometimes the simplest things can stump you for hours on end lol. Cheers!

Pictures are worth a thousand words The image is a subform that is displayed in datasheet view when executed. I have a check box called “exclude” The purpose of this is to exclude specific results from the data when performing calculations. In the footer I have several text boxes which I use...