MS ACCESS 2003: I have many linked tables - where at the very end, the >* option is lit-up and I can go to the bottom and add a row if I want to.
But, there is only one - where this is ...
I have a combo box set up on an Access form which allows the user to search by client name. When the user types in the first few characters of the name and the name is displayed in the combo b...
I've created a database for Workmen's Comp using Access 2003. Attach is a sample of my database. If you look at the form you will see that I set a criteria for Adjuster_Company and a command...
Hello!
First off, I'm very new to access. I've got my database together and I've developed a form based on a query. The columns have dropdowns in the form. When I change the dropdown option...
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 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...
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 ...
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...
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...
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.
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...
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 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...
I am using access 2007. I have a table of 512k records and it has 7 fields. In my duplicate records I have 5 fields exactly same and 2 are different, but they are still considered the duplicat...
Hi,
having a table A which looks like:
DATE X C1 C2 C3 Nobs1 Nobs2 Nobs3
12/31/1990 60 ...
I have had occassion to attempt using this function many times during the last fifteen years, I always try it, I always think I will be able to now figure out the mistake(s) I have made in the...
I know DLookup will capture one value. How do I create a function that will lookup more than one value?
i have a dbase. i want some type of security or a password prompt or something so users cannot minimise the startup form or any of the forms to gain access to the tables, etc
when the dbas...
