Search results

I have searched and searched... but I just cannot find this. I know it has to be in here somewhere. Any help is greatly appreciated. I have a query called "MyLateProjects" that shows results based on a specific number of days since the "project" was entered in to the database. I need to be...

Allow me to quote myself... "I have a table called "Entry", with a form called EntryForm based on it."

Thanks for the help... but I need one more thing to finish this. This is what I have so far: A module that reads: Option Compare Database Option Explicit Global UserSignIn As String A form field caled Emp_Name to accept the sign-in name, and a button on the form that has the...

OK. I think I understand. It makes sense to me. Now, in the case that I have multiple users using this functionality at the same time, will the 'global' nature of this feature overwrite content from one user tothe next... or is it contained within each user's session like filtering forms...

"global variable?" That sounds promising, but I am not familiar with that functionality. I'll do some searching. What would the syntax of something like that look like? SomeVariable = Me![Username] Then close the form? Could it possibly be that easy? Thanks again for your kind help.

In this db, the users select their name from a dropdown in an auto-open form, but with no password. I want to capture this value for use as the default value in a field on another form, but with the first form closed. I have seen the ENVIRON(Username) function referred to many times on here...

To administrate sales orders, we check up to thirteen contracts (let's call them A-M) that may be included in a submission. The Specialist, to create an audit trail, must first indicate that a certain contract is "Required" by selecting the appropriate checkbox. Once that contract has been...

Try this =if(mod(month(n5),3)=1,n6,if(mod(month(n5),3)=2,m6+n6,if(mod(month(n5),3)=0,l6+m6+n6,"error"))) --- --- --- EDIT: Actually, it might even be easier than that, if you guarantee the entries will always be dates...

Hi all... and thanks for your help to this very frustrated moderate Access user. I have been using an example for cascading combo boxes in a timesheet form, but I simply cannot get it to do what I need. I have a table called "Entry", with a form called EntryForm based on it. That table has...

Hi all. I replaced my laptop when the hard drive crashed, and got a new hard drive for the old unit for my grandkids (age 4) to use for games. Sometime during the last four years, I have misplaced the restore disks and now have no OS. Does anyone know of a resource to get Windows cheap? It...

We have a billing scheme in which we partial-bill ceratain customers based on certain events: 30% when they sign the contract, 30% a number of days later, 30% when we ship the goods and the last 10% upon installation. This is a common process, known in many indistries as 'progress billing.'...

THANKS so far. I am working through this... slowly. Thanks for all your help so far. So, make sure I understand... I have the module that calculates mlfWorkingDays. I can base my form on my table that has StartDate and EndDate in it. In the form, I can have the WorkingDays control. Then...

Thanks. I have seen similar modules as well. Once I have created the module... then what do I do? I am assuming I write a query or create a form in which I can refer to the module... but have no experience in the syntax to make hte reference to it. Thanks again for your help.

Hello. I've been trying very hard to get through the various instructions, code, modules, etc, on calculating workdays. I am having no luck in getting this done. As one who can write an Access database only to the point of a little VBA, using mostly queries and formulae to get by, I have...

I have this (new line at commas for clarity: =SUM( A14*SUMPRODUCT($E$12:$L$12,E14:L14), A15*SUMPRODUCT($E$12:$L$12,E15:L15), A16*SUMPRODUCT($E$12:$L$12,E16:L16), A17*SUMPRODUCT($E$12:$L$12,E17:L17), A18*SUMPRODUCT($E$12:$L$12,E18:L18), A19*SUMPRODUCT($E$12:$L$12,E19:L19)...

I am attaching a pic of my relationships page to show the table structure I am dealing with. What I need to do is match forecasted values with actuals based on the same date range, sales_num and unit. The two tables that hold this data after downloading from our systems are ForecastOE_T...

I have a database of submitted orders that were temporarily held by our Order Management group for any one or more than one reason categories. There are 20 possible errors that could cause this temporary hold to occur. Once the error(s) is/are fixed, usually by getting missing information...

Also!!! I use this kind of code to have subforms visible under certain circumstances as well. But, if you do something like that, make sure you repeat the code in the On Open and On Current events as well, so that as you open the main form or move between records, you will get consistency in...

Is this a Yes/No checkbox or is it a radiobutton? If it is a Yes/No checkbox, the value for Yes is -1 (negative 1). Otherwise, it sounds like a simple IF ____ AND _____ THEN statement type. I believe that any code would go in the AfterUpdate event of the checkbox to drive what you are...

Any help will be greatly appreciated. I'm sure I'm not the first to encounter this, so any ideas are welcome. Thank you!