I would like to show a menu bar based on the users group membership. I'm thinging I can do this using a select case statment in the autoexec macro. However, I'm not sure how to get the users...
Hi Experts,
I'm just wondering if it is possible to open MS Outlook using VBA from a click of a button on a form?Is it possible to open MS Outlook using VBA from a click of a button on a ...
Here is the scenario...
Customer X has 20 outstanding invoices in my database.
Customer X sends in a check for an amount that doesn't match any of the invoices. It's a combined paymen...
Is there any way to set a max character limit for a memo field so that it doesn't cause truncation when being transfered to other dB programs?
TIA
Ewen.
Hello Experts.
I want to change the properties of the cmdSendEmail button to cmdSendEmail.Visiable = False after the email is sent. I can not do it within the cmdSendEmail_Click() event bec...
I have created a master report with many subreports and associated queries.
Purpose is to number the pages sequentially for a report package.
Worked great until I hit a wall -- a jet erro...
What is the best way to check for user inactivity and close the database after x number of minutes of user inactivity?
I have been working on a new database application in Access 2007 and the database is 35 MB. I have compacted and repaired - n o change in size. I also decompiled - no change in size. I even...
I need help refreshing how to do this. I want to check some fields when the user closes the form to make sure they are filled. If not - cancel close and set focus...
Private Sub Form_Unlo...
I have a combo box that has the ID and ITemNO in the pull-down.
This is at the top of a continuous form that displays all records involved.
I would like to select an "itemno" from the co...
In the attached MDB "Onsite Registration" button opens form onsite_registration. I need a button that fills in Order #, and advances to the next blank record so the next person can register
Ok On a form I have a list box but I need it to be sorted by ascending
could I have assistance with the correct line of VBA codse to achieve this?
Private Sub Combo46_AfterUpdate()
' ...
How can I create a list of all checkboxes in a form?
I've tried the following but have failed to make it work.
any kind of help is much appreciated.
I need to transfer data from one table to the other. In tbl_SoftwareTransfer I want to transfer the data from the following fields, SoftwareName, SoftwareCompany, SoftwareVersion, SoftwareKe...
Hello,
I am looking for the correct statement in Access - "does not start with".
Currently I am using Crystal Reports and it shoes the folloing formula
"not ({OL.OL_EXP_ACCT} startswith ...
I have a form with a linked (child-master) subform. I only have a problem when I am entering more that one set of records at a time. Between "ADD"s - the subform does not clear - it seems to b...
I need help associated text detail with a particular task as entered in frmAddTasks and shown
Later I will want to associate detail with a day as opposed to a task but just task for now and O...
in another post i was advised not to use linked tables in my sql database.
at the moment i'm developing our database in access with the hope of transferring to our sql server.
are linked...
I have a very simple database setup that seems to be getting more complicated as users continue to ask for more things. It is in Access 2000 and is 1 table and 1 Form. If a user makes any chan...
Here's the setup.
Access 2003
1 form
1 report
form has student name combo (pulling from user table), and a class combo (pulling from a lookup).
I dont need to remember which student too...
My main form has a couple of queries showing data from the database. I've got two buttons where a synchronization to the replica will occur; one allows the user to synchronize, the other sync...
What is wrong with this?
=Sum(IIf([NamedInsuredLocationApplicable]=True,15,0)+IIf([ConstructionTypeYearBuiltApplicable]=True,15,0)+IIf([BCEGsApplicable]=True,25,0)+IIf([CDSValidationApplica...
Hi, I'm using Access 2003. I have a SELECT statement in one of my VB.NET applications that gathers data from one of the Tables in my Database. It works fine until I try to LEFT JOIN multiple T...
Experts,
I'm using the Last function to get most recent date ([LastOfDate]). However, I can't figure out how to get the 2nd, 3rd, 4th, etc. most recent dates. I'm substracting the weights (...
I have around 100 spreadsheets (each is like a "prcing contract" record that have header and detail information about the pricing. For instance,
Header - Contract#, BeginDate, and EndDate
D...
