I'm wondering why when I converted a Access 97 database with code to Access 2003, the code within it runs a lot slowly. For example the code below queries data from a sqlserver 2005 database a...
I am running a function that checks outlook for unread emails.I would like to stop the code from executing iof outlook has focus and also to determine if the widowstate of outlook.Thanks
I have a small Call-center app develped in MS Access and sql 2005 backend. I want be able to notify, via TEXT MESSAGE or EMAIL, of occurances while taking information in a form.
Is ther...
I have a report I've used for several years now - it's a very simple report; header, footer and detail. Suddenly now when I preview the report, I can SEE the header, but it will not print. I...
Hi guys!
Here's my situation, I have a MS Access Database, that i will use to store file paths. and I have a VB.net 2005 Form that I will use to open the files using the filepaths i stored ...
I would like to have a count, a text string, and a date in a report header but I get an error with
=Count(*) & ' registered ' & =Date()
I can put each in its own text box, but I get tabs b...
Hello,
I have this nagging problem of not being able to delete records from my form with a subform on it displayed in datasheet. I click on the row and hit the delete button on the keyboard ...
I have adversely changed a query that feeds a form that's set to open on opening my MS Access file. Perhaps I made a change that is querying too many records.
Therefore, I cannot access th...
IS there a Time Picker control where instead of the user entering a Time he or she picks it?
I thought there was an ActiveX control but I can't find it.
I have a chart in a MS Access Form. I select the customer I want the chart for through a dbl click on a customer list. A macro runs and opens up a form showing 52 weeks of sales data for that ...
Hello experts,
I was looking into doing a project and found this little nugget in my travels.
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_233525...
Hello Experts,
I asked the initial question yesterday. I didn't do it exactly like this, but the solution got me moving in the right direction. Instead, I created...
tblMenu with cycleID a...
Hello! ok, I'm trying to write an iif expression so that if one condition is true I set the value, and if it is not true then the field is left blank for the user to enter the value... I'm sur...
Is it common for a freelance programmer to sign over all intellectual property rights before beginning the job? Is this something you would do?
If a programmer always did this, how would he...
I have a saved query.
The query is in a child-form on my main form.
I'd like to be able to change the query to say, filter only the records within a certain date range. Is there any way t...
when I view the relationship screen in access it looks like the top inch or so is cut off and I can't scroll up any more.
Was able to view everything fine and then all of a sudden now I can...
Hi
Is it possible to install 2 different access runtime applications on the same PC?
Many thanks
I have copies of a database located on a couple of company servers. Is it possible to determine the PATH used to launch the local MDB file?
Knowing the PATH would provide some level of cus...
Hello Experts!
I am trying to populate a data table based on various other tables and running into some trouble. I'm hoping you can help.
I have a table which contains the following fie...
I have two front end databases referring to the same set back end databases. One front end database handles our general project information and the other front end database (in development) h...
I have a multi-user database that holds work items in a "bucket" and pulls the oldest item down to a user's workspace when they click a Get New Item button. This is done through a SELECT TOP 1...
