Hi:
pleas, How to Prevent the Mouse Wheel from Scrolling Through Records in a Form
I am trying to scan images into an Access database. This seems like it would be fairly common task but I can't seem to find much information on it. Here is what I am trying to do.....
I wou...
I am using the following code to see if a user inputs a name more than once:
If DCount("*", "TMain", "LName = """ & Me.LName & """ AND FName = """ & Me.FName & """") > 0 Then
This...
I know this must be ultra simple but I somehow haven't had to do this until now. I tried searching the other questions but no luck.
I want to use a combobox linked to a lookup file to sele...
Is there a way to close a database by using it's name?
For example...
tblTest1.close
instead of
rs.close
I have 2 textboxes: tbDisc and tbResult.
The user enters a percentage into tbDisc and the discount shows up in tbResult.
The control source of tbResult is:
[tbDisc]*[calTotPrice1]
Obviou...
I have placed a label on a subform that is visible at design time, and if I display my form in form view but it is not visible in datasheet view.
Does anyone have any suggestions on how to ...
I have an access form with the following row source
SELECT Shop#, City, State, SenderID, SenderPW FROM Shops
I am only displaying the first 3 fields in the list box
I was hoping to se...
I am trying to get a file from any local folder using a browse button. After getting the file and using the textbox to display the path and filename, I would like to save it to another folder ...
Is it possible to capture the value of a text box (text box data type is text) and concatenate this to the caption in a command button?
If I have a text box with the value 1234 and I want a ...
I have several lines of VBA code that is used in 3 different forms. So in an attempt avoid code duplication, I put it into a subroutine in a module outside the forms. Unfortunately, I have to ...
I want to place a button on my form that will open my browser and link to Google Maps for the office that I am viewing in the form. The google Maps API info is way over my head and seems more ...
I am trying to create a simple "browse" button in which it opens a directory tree and filters images (.jpg or .bmp) out of it. I started coding it below but it is complaining that "dlg.Selecte...
A form with a Listbox contains list of components and when multiple selections are made the query should find only samples containing all the selected components.
I feel really dumb about this but I had an issue solved for me that I now cannot duplicate. Someone had solved my problem of not being able to search form a form (frm_ComputerName4) in a field...
I have a combobox in a subform that utilizes a query as the data source. The query is filtered based on the values of two text fields on the main form. Currently, text field 1 (txtOD) will a...
I created a form with an On Open Event Procedure (code to follow) that asks the user for a customer # then runs two Append Queries that finds that customer's information in two different archi...
I need a chart that shows one full day. (something like a time line?)
On the chart I want to show blocks where there is a "log" entry.
There are two types of "logs" and I want them to show ...
Hello,
I have a 'Inventory Detail Form" that has a record source that is a [Inventory table]. My [Inventory table] has a [Item Code] field that I am trying to filter with a combo box withi...
Hi Experts,
I have a command "Add Case for Existing Client" that is proving to be quite difficult. The user wants some of the demographic area to autopopulate the form but the record is a ne...
Hi,
I have created a form for member information. I need to update that form so I created another table with same fields and created update form. When i enter information on update form an...
What is the best code to delete the folder and its' contents in the current path.
(1). This is not a windows permissions error I believe, since the user logged in as an administrator -
...
I created a database in Access 2007 to allow our group to collect information on what software resides on the Dev, Prod and Test servers. I would like to create a form to email to the differe...
Hi, I'm using Axys2003. I've cut and past the solution into my unload trigger from the form:
If msgbox("Are you sure you want to close this form?",vbyesno,"test")=vbno then
cancel=1
en...
i am trying to run a query. Quote_ID generates the right data, but if I select tblQuote_Order!Quote_ID and set criteria [Quote_ID], it does not work.
