Search results

OK that works for the macros. Now I noticed that I can import all my linked tables from the mde. That's not good. Anyone know a way of securing the tables and maybe even the queries from an mde?

Is there a way to password protect the autoexec macro? If not, how would I go about securing that macro? I've noticed that you can import the autoexec macro to a blank database, manipulate the autoexec (i.e. disable shift-key bypass) and export the autoexec back into the database. Note: the...

Thanks for the quick reply. The form that the button belongs to is a timesheet that an employee will fill out. The button would serve as an Approval of their timesheet because it would export a PDF report with timestamp of this timesheet to a folder. The last part is just hypothetical right...

I have a form that has a button that I would like to disable once the time passes 4pm on a certain date. In the ol' days there was a hack where you could simply change the system time to several years back and it would bypass an application's serial code's validation. I believe someone could...

I was looking for something similar to this but I wanted it to work more like a web based star rating solution where you hover over the stars and it changes accordingly. Much like on some review sites. The code can probably be cleaned up but it works. Just click on the stars and it will bring...

I have a report that looks like this. There are columns for an ID and 52 weeks: ID..Week1..Week2..Week3..Week4..Week5..Week6..Week7...Week52 1...45C......45C............................38.......38........38... 2..............22B.................21........21..................28A...

I am trying to reference 52 textboxes on a report. I am calling the sub AssignToWeek from the open event of the report. Below is a partial listing of the sub AssignToWeek. I am getting an "Object variable or With block variable not set" error for the line of code in bold. Can someone...

Needless to say you're a genius HiTech. Looking at your code was like having the blinders pulled off my eyes. I was banging my head on this little piece for a very long time. Like you've been saying all along, I was trying to load and populate the calendar at the same time when I should have...

OK, did what you recommended and nixed hlDates and changed highlightCalendar to highlightDates. I've been racking my brain on implementing a loop to highlight the assignment dates green. Here's the code I'm using: Do While Not rs.EOF Call highlightDates(frmControl, Nz(rs!AssignStartDate)...

OK, baby steps here. I've separated the original loadCalendar into loadCalendar and highlightCalendar. And I've added a function called hlDates that highlightCalendar calls. The names can probably use some work but that can be taken care of later. Everything is working just like the original...

Thank you for taking the time to look at my code. I'm pretty sure I didn't explain myself that well on my original post so your patience is much appreciated. I will definitely try these recommendations. So you're saying one method would be to load the calendar only and another method to only...

Thanks for the response and tip HiTech. I have fixed the references and uploaded revised db. I've tried looping through the subform's record when loading the calendar but nothing happens. I believe it's the way my if statement is set up for my green highlight code.

This forum rocks!! I have found sooo many helpful tips and tricks here but I am finally stumped. I am in no way an expert with Access or VBA so my code might look amateurish at best but it works. I have attached a sample db for reference as my explanation might not clearly explain my...