Dear All, [Access 2010.]I designed a database that should allow us to record, process and output hotel contract rates. Recipients want to receive the processed...
Greetings All, My work computer was updated to Windows 7 and Office 2007 last week. The first few days everything was working fine. Now, whenever I attempt to...
Very soon I am going to have an end user start to use my database. However I do not really want them to copy the database file and then distribute it without...
*I need to modify a form to add a listbox--which I've successfully done. My problem is getting the information for the person I click on in the listbox to show...
Per a book I was reading I was giving the code below to use a keystroke combination to run a module Private Sub Form_KeyDown(KeyCode As Integer, Shift As...
I am using MS Access 2007 and have a need to turn on and off a filter of records in query. Specifically I have 2,577 records total where the estimated...
Hi All,... I want to set up the Pop Up property on a current Form with this code : Me.PopUp=True that code is assigned on a command button on the form, but it...
Hi, I'm struggling to create a running total in a query using DSUM. Here's my statement: test: DSum("proc_hrs","Query2","jobno <= " & [jobno] & " and...
Good afternoon/evening! I have a query which populates a field called Cities with a concatenation of the Cities a buyer is looking for. A sample field looks...
Hi Bill On the Access Developers forum you posted the following code in response to a question I asked on son=meone else's thread. I'm having trouble with it....
Hi, I am using MS ACCESS 2007. Whenever I am trying to build up Switchboard, I am not able to view the tools for creating a command box. G. A. SHANTHAKUMAR...
John, The multiselect boxes are wonderful! Now I'm working on creating the filter to pull up the LookingEvent (buyers). Aargh!!! As we talked about, from a...
Elizabeth: I have been knocked offline for couple of days due to a cable to FIOS conversion (finally done) at home. But as I use very similar code, I have been...
Hi, I have a back end/front end set up that is used by about 20 people (not all at once). A few people have reported one list box on one form has no values in...
Hi All, Thought I had this concept figured out but I don't. I have: strWhere = strWhere & """ & strC & """ & " IN ([Cities]) AND " The strWhere is working but...
Hi All! I am working on creating a form where the parameters that a buyer has can be entered. A couple of criteria can have several items in one category...
I am currently unable to add a record to my main or sub forms. I am not sure why the problem exists. Please provide assistance. Regards, Debbie Okoli, MSPH,...
Hi Folks, A while back I saw a discussion (in this group,I believe) of currentdb.execute. Several people made the point that it is better to declare and...
Hi Gang Just thought I'd share a URL with you. http://www.bullzip.com/ has a bunch of little utilities that you might find useful. They are all free and the...
Hi all- I have an Access 2003 procedure to do a Word 2003 mailmerge. It works. If I put this procedure in Access 2010, the Word 2010 save as dialog box pops...
Good morning! I've put a query below where each field has "Or Is Null" as part of its criteria and therefore it returns all records. (The values that it is...
In order to run a Report, I open a Form where I enter selection criteria, the selections are passed to a Query and the output from the Query is used as input...
Hi, I am uploading a zip file to explain my problem. FILE NAME:CrossTabColumnReOrderingProblemOzair.ZIP ( Assistance Needed ) I want 'Shipper Name' to appear...
Good afternoon, I have a query which returns about 145 records based on Allen Browne's ConcatRelated which is VERY slow (about 7 seconds to load). It uses...
Hi everyone... I Have a form that has record source to a table "T_PWD" with 2 fields "UserName"; and "Password";. On that form, there is an image object named...
The form shows this message when I attempt to update a field. In the 'Open' event, the VBA retrieves records based on criteria defined in the 'where' clause. ...
Hi Crystal, Giorgio, (I have raised this as a new thread because Giorgio's post is tangled with another thread and you may have missed it.) I have also had...
Good morning! The Listings form has the option of opening with a current listings or all listings. Today I found that when the button "Off" is clicked it...
Hi All - I have been trying all day to copy, export or import a form from one database to another. I wanted to copy the form so that I could redesign it...
