Search results

Hmmm. I already have something in the "On Current" event. I am using a filtering addin, so my On Current event is "=aadHandleButtons([Form])". Any other suggestions? I have done this before, but can't remember how I did it. Thanks for the help. Jim

Thanks but where is this located? I can't find it. Jim

Just wanted to ask for help again since no one replied. Thanks, Jim

I have a table with fields ID, NAME, ITEM, QUANTITY and DATE_IN. I have a query "qry_Logged_In" based on the table. I then have a form based on the query. I created a combo box as a "go to record" selector and used the following Row Source: SELECT DISTINCTROW qry_Logged_In.ID...

Just to make sure, how do you recommend getting your calendar and module into my project? I know you can export it from yours or import it from mine. I tried import first but import did not see your calendar or module so I had to export from your file. Also, other than the module and calendar...

Yes and when I double click the date field, the calendar does pop up as it should. However in my project that I imported your calendar and modules, it does not highlight the date when clicked on by making it look sunken. Here's a link to an image capture of your calendar and your calendar in...

I exported the Calendar form and Module to my database, then called it from the date field like you did in your demo. It seems to work except when you single click on a calendar date, it does not highlight that date. It does in your demo, so I am not sure what the difference is. Thanks, Jim

I am using Access 2003. I have a form with two text fields that I have configured as "Short Date". I set up Calendar Control as a new popup form (frm_Calendar) and set up the date fields to popup the Calendar on double click. I have 2 problems. 1. The calendar does not want to default to...

Duhhhh.....:eek: I forgot to check the obvious. Sorry for the inconvenience. Thanks a bunch.:D :D I am glad it was something simple. Jim

I have a spreadsheet that I use as a group calendar. I have an autorun macro that looks at a cell at the end of the spreadsheet which has the code "Today()" searches for that date (today's date) on the calendar, then moves the focus to that cell. Recently I started to get a Runtime Error 91 on...

I have a database with the folowing fields NAME (Text) ITEM (Text) DESCRIPTION (Text) QUANTITY (Number) IN-OUT (Combo Box "IN" or "OUT") DATE (Date / Time) LOG_BY (Text) This is basically a log to keep track of items logged in and out of a secure zone. I want to create a query that will show...

Can you expain this a little further? Maybe plug it into my current calculation: DAYS_OPEN: Nz([STOP_DATE1])-Nz([START_DATE])+Nz([STOP_DATE2])-Nz([START_DATE2])+Nz([APPROVAL_DATE])-Nz([START_DATE3]) I really appreciate the help. Jim

Lets say I have an Access database called "GroupReport.mdb". That database has several queries "group1", "group2", etc. that pulls data from an external data source to show open work orders for that particular group. And lets say I have an Excel spreadsheet. In that spreadsheet I have column...

I guess no takers? Any suggestions? Thanks, Jim

Can anyone help me with my final delima? Thanks, Jim

After some thinking, I tried to simplify this a little. Basically what I am trying to do is calculate the number of days a project is open given a Start Date and the ability to stop and start the counting date several times. So here's what I settled on: DAYS_OPEN...

I hate to make this more complicated, but can I integrate this with an IIf statement so that if the status field is "In Progress" it calculates the days open using todays date minus the start date, otherwise it calculates the start and stop dates as described above. Bottom line, should the...

I will. Fortunately for them this is not for anything related to pay. They are salary folks anyway. But I think it's stupid that we have a 60 day clock to get projects done, but management allows that clock to be started and stopped. Go figure:rolleyes: Thanks for the help. I will give it...

Can you provide a few more details? How would I write that in the Query Field? Thanks, Jim

In a database, I have the following date fields that I use to track projects that start and stop. START1 STOP1 START2 STOP2 START3 STOP3 Is there a way I can use a query to calculate the total days the project was worked on? For example if I enter 1/1/06 in START1, 1/10/06 in STOP1, 2/1/06 in...