Search results

DAvg () shows Blank instead 0 when there's no data Gentlemen: I have a YTD employee data report, from Jan 2008, I added a new category called Flexible Tasks, previous to that date it default to zero. I used DAvg () to get the average total, however if there is zero data for 2008, the formula...

Hello, I have two columns on a table, one Col A is an integer with zero decimal places and in Col B is formatted to 3 decimal places (0.020). On the Report I have a textbox with data source formula: = iif([Col A]= 0, [Col B], [Col A]) If I format the textbox with 3 decimal place and the...

Hello, I have two table columns, one Col A have zero decimal places (integer) and Col B have 3 (0.020). On the Form, the textbox's data source = iif([Col A]= 0, [Col B], [Col A]) However, if I select decimal format 3, the interger will result to 2.000 while if it's the other it will cut it...

Oh Hello, I password protected my codes on the Visual Basic Editor, however, the users cannot save the file. Is there a better way to do this? Thanks,

Hello After spending a lot of time figuring this out, I think it time to call on the experts. I can't make my sql work on rs(1).value. I keep on saying "object variable or block variable not set" I copied one in my module that works but won't work here. I am lost in translation. Private Sub...

Hello, I have an existing table with data and I added a new column with a default to zero. When I query the table-column the results will show zero content for the previous dates and data for the current dates. I have a " =Avg([theColumn]) " on a textbox. The result in not correct, it counts...

I have a monthly report that query a table for stats for various users with calculations and print results. I would like to capture those data to another table for year-to-date performance ratings. I created a module that contains a public type Final Results variables. On the report module...

Hello, Can you provide me the link for the code to prevent deletion when updating the front-end mde file. I accidentally ran my master copy and deleted it. Thanks

This is a continuation of my thread posted 2/21/08, solved by Rolaaus. Reference: Log In and Log Out Information Save. The Log Out is now working, saving the posted date-time information only when the exit button on the main menu is selected. On the main menu form properties, the Close Button...

User's Log in information save, gone at log out Hello, How do we able to save user information at login and have it available at log out (Id and password). I was able to save log-in information but the variable is empty at log out. Can you help?

I have an issue and I tried every trick I could find and I need help from the expert. I got the idea on one of the thread but I have to revised to fit my database, however, I have a problem keepping the Users Information to memory and use it to stamp the date/time on exit. I tried to use the...

How can I protect my tables and queries on a MDE database using shift + click? The users also knows how to unhidden the objects?

Hello, Will it improve my setup or will it work? My production database is base on your idea that FE should contain queries, forms, reports and link to BE for data. We have two site groups in the same network share my FE. The two sites data are also combined on the BE. The other site (#2)...

Hello! I followed boblarson - Access Front-end Auto-Updating Utility procedure. I tested the procedure to a smaller database following the procedure, it stop after it deleted the old copy but tried different ways and made it to work. Applying the same on a much larger database with lots of...

Hello All, I have a production database on our G: drive which features employees various reports up to the creation of a scorecard. Since most of my users are not computer/application/database savy, to protect my database from deletion, I keep important tables in separate database. The Data...

I imported a form from another database that I have, the form works, however, it won't work on my new database. I checked everything including the references, I can't find any different, I don't know where the problem is? I am using Access 2000 (9.0.7616 SP 3). Please Help! Here is my codes...

Hi! I have vacation schedule file, on column A are names, from column B and so on are date of the month. I would like to create a drop down list on every cell to select whether a employee took a Vac, Sick, Pers, Hol, 1/2Vac, etc. When you click a cell a drop down list appears and when you made a...