I am developing an application and have many system numbers that must be combined with another system code. System code is unique such as CBTT-( the number Located in this setion must start o...
Hello Experts,
There's (no doubt) an easy way to do this, but I can't seem to find the solution.
I have three text boxes on my Access Form.
Textbox#1 = My first textbox captures the num...
My dilemma: I want a form to appear blank when it is opened and for the user to then select the desired record from a combo box. I have the combo box programmed and all works well with select...
hello experts! is there any way to set the back color of a command button on an access form?? I can only find fore color under format... thanks!!
Hello Experts,
I might be trying to do this all wrong, but I thought it would be simple. I need to create an XML file from a table in a ACCESS 2003 database.
I can do it by Right Clicking...
I'm opening a form in Dialog mode. Using ADP.
I created my own shortcut menu. The standard Find wouldn't work, so I coded my own Find.
The standard Filter For, Filter By Selection, Filter Ex...
Hi
I am tryin to make a contact form that should submitted to an action page that should store information in database and also it should send email to me and another email to that user who...
Hi
I would like to force the first character of a field on a form to upper case and then allow the rest to be optional. I know how to force to upper case and lower case, but I want to turn...
Hi,
I'd like to send access report by email.
I found in network code:
Private Sub Command128_Click()
DoCmd.SendObject _
acSendReport, _
"Letter", _
acFormatRTF, _
"tes...
hi,
i have calculated date field called Date_2. It is calculated field Date_1 + 10 = Date_2
when I open the form Date_2 display #Error, because Date_1 is blank.
how can I display Date_2 B...
I have an Access table that the fields are answers to questoins. I want to create a form that I can choose a checkbox that will select the questions to run for a report. Any suggestions - ideas.
Hello,
I have 2 buttons on a custom ui ribbon that I created, "Previous" and "Next". When clicked, they run a macro that moves to the Previous or Next record on a form. If I am on record 1...
How do I mix text and field values on a control, and forcing line breaks?
Lets say I have fields firstName and lastName
and I have a textbox. How can i insert more than one control source?...
I use the following code (thanks to EE) to successfully add and delete fields programmatically. I need to modify the attached code snippet to delete a field's Index before I can delete the fi...
The attached code snippet works and creates a table with two columns, TableName (the names of all the tables in my .mdb file) and Field Name (all the fields in each table).
I need two more ...
In Excel I can "freeze" the appearance of the window while a macro runs in the background updating various cells in a spreadsheet and then "unfreeze" the screen to reveal all of the changes. ...
Can someone please tell me why the code below limits the number of records allowed to be added to the listbox. I can only select up to 32766 and then the by val is blank in the access form. ...
I am trying to track the amount of time (in seconds) a call center agent is talking with a client. The telephone tells the agent the time in mm:ss (minutes:seconds). I want the agent to ente...
I have a form showing up to 20 rows of data (records). The user has to check all rows for correct data with a paper document, created by someone from another office. The sequence of the rows a...
I am creating and if then statement in an Access for to have something show on a form if something is selected.
If me.checkbox1 = 0 Then
If me.checkbox1=0 then
Me.lable1.visible = Fal...
Hi Expert,
I have a text field called Begin Date, I want validate text user entered to make sure it is date before form submit, for example it should be 10/1/2008. How i can do it?
Thank...
I have a combo box using the following query:
SELECT items.item_name, items.sale_cost, items.category, items.number FROM items WHERE (((items.discontinued)=No) AND ((items.item_count)>="1")...
Hi:
I am a talent manager who has to coordinate many client meetings. I use an Access 2003 database to coordinate these appointments. I use a form and a subform to enter the data. I woul...
How can I obtain a single vertical scroll bar for entire form (screenshot and database attached)?
I have this irritating problem since switching to Access 2007. When working anywhere within Access (form design, navigation bar, etc) whatever is directly behind my Access window bleeds throu...
