Search results for query: *

Hello!! I have been working with Access for many years, but came across something I can't find out to fix. In years past, when I was using the properties window, if I clicked on any of the events, in the bottom left of my access window, it would give a little note about when each event would...

Good Morning!! I currently am using Access 2003 vba to export data to an excel pivot table via automation. The table creation works great - and I have added a column to the end of the table to calculate percentages on 2 of the rows (it looks like this): ClosedBy (All) Closed (All)...

Help :( I have HOURS into this database setup, and noticed all of a sudden my ENVIRON("USERNAME") was not working.. I thought it was acting funny based on other posts(i.e. not reliable), but then tried it as a function/api instead - still didnt work, then I noticed that NONE of my code is...

hello all! My issue is this: I have a main form frm_Tasks with a suform frm_TasksTracking. Because this will be used heavily, I want to NOT force the users to click a button or 'goto' a new record, I want to the New record on the subform to auto set when the form loads, and when navigating...

I have a Simple Database with a parent and child form. 2 tables - parent and child, with ref integrity enforced. I am getting an inconsistent error upon typing the first value into the subform record: You can't assign a value to this object. *The object may be a control on a read-only form...

Hey guys! I am almost done with this automation and hit a snag. I had the public routine in a module, but reading found that I couldn't call the routine from a command line for task scheduling (please advise if I am wrong). The only way I can find to call this, is to create a function and...

HI! I've been working in Access for years -but - admittedly - there are some areas that I've never had need to work with - charting is one of them. Now I am doing what should be a simple chart - and I am sure it's an EASY fix - I just can't find it. TRANSFORM Sum([OpenDays])*1 AS...

Hey all, I've been searching and can't find exactly what I need - Part of this may be due to not knowing EXACTLY what I am looking for ;-) I am pretty sure I've done this in the past, but I've been out of the loop for a couple years (working with other software) - and am pretty danged rusty -...

Hey all - this is a cross post - sorry - Just trying to find out why the database window will not stay hidden in my application and if it's a bug that someone knows about. I've disabled bypass keys, hidden the db window, and it doesn't show up until I hit an error of some kind - basically a...

Hey all, I am getting very frustrated. I have hidden the database window, disabled bypass keys, done everything I can think of to get the database window to hide. It hides and stays hidden just FINE until any kind of error occurs. Even though the errors are handled, the fact that the error...

Hey all, I was just reading in the new FoxPro certification study guide, that on the exam, incorrect answers are penalized, so if you don't know the answer, you are better to skip the question entirely than to answer it wrong - can anyone confirm this?? I historically at least GUESS at an...