Wondering if anyone found a solution to this yet:
'Put cursor at the end of the text box
Me.txtBoxName.SetFocus
Me.txtBoxName.SelStart = Len(Me.txtBoxName)
The problem now is that even if 2/3 of the textbox is whitespace, the scrollbar still scrolls to the bottom of the box.
Anyone...
Just wanted to send a congratulations to BobLarson, theDBGuy, and PBaldy for their efforts noted on utteraccess.com. Their generosity has extended here, to Access-Programmers Forum, and though there isn't an official "recognition" page, they still deserve it.
Hey all :)
Does anyone know how to force the value of a listbox to refresh, without refreshing the form?
The form has a few controls that are based off of linked tables so I don't want to call the Me.Refresh if I don't have to because of delay times and performance issues.
I am doing...
I was wondering if someone has had this problem before:
I have a textbox on a report with the following control source, where SupF and SupL are the supervisor's first and last name respectively:
="Supervisor: " & [SupF] & " " & [SupL]
What is being displayed when the report is run is...
Just wanted to start something for everyone to contribute to. Thought this would be fun.
Create a code-formatter that is able to take your VBA source code and format it for color and spacing to place in the forums. I've begun by loading in the reserved words into a table, with the color...
I'd like to see a section dedicated to people willing to pay for access projects, or people who can post positions open for employment at their company.
Please don't criticize the naming, I've renamed to make the logic simpler to understand.
I am trying to run a query based on the value of a textbox. Right now if the text box is empty it shows all the records. This is what works:
SELECT A.ID, B.Weight
FROM A
LEFT JOIN B
ON...
For some reason I didn't think this was possible, but I didn't want to throw all my cards away. Let's say I have a button called cmdButton and I would like to call cmdButton_onClick(). Does anyone know a way to do this by using a string.
For instance,
Dim sCtrl As String
sCtrl = "Button"...
I want to attach labels to their respective controls (e.g., textboxes, comboboxes). Does anyone know how to attach the labels to the controls?
It used to be that Access would produce a little error box that said they were unattached, but that is not coming up anymore. Tools>Options>Error...
I am trying to make a simple chat interface for a database.
There is a standard form I use as a template for chat between two people. When a member dbl clicks on the buddy list, I use DoCmd.CopyObject to copy the form for the two people. However, the CopyOjbect only works when only one person...
The best way to handle this is to show you what it looks like and go from there, so please see the attachment.
I have a subform used to track machine-part orders. The subform is bound to a table that has:
- Part Num (PK/FK)
- PO Num (PK/FK)
- Paid Price
- QTY
The Part Num field is a combo...
I have a button that has the ability to change two text boxes, depending on which one has focus.
Does anyone know how to verify if a conrol hasfocus?
If Me.ControlName1.hasFocus Then
Me.ControlName1 = GetValue()
Else If Me.ControlName2.hasFocus Then
Me.ControlName2 = GetValue()
Else...
My openargs look something like this:
"Form=Main;MondayOnly=True;X=2500;Y=800"
Dim args() As String
ReDim args(UBound(Split(Me.OpenArgs, ";")),1) 'resizes the 4 by 2 array
args = Split(Me.OpenArgs, ";") 'correctly puts each section into array
'--------------------------------...
Hey guys, take your time with this - i'm not in a hurry, it's just slipped my mind.
I'm reseting the form controls back to their default value. My code is as follows.
For Each ctl In Me.Controls
If ctl.Name Like "cbo*" Or ctl.Name Like "txt*" Then
ctl.Value...
I'm making my own custom calendar and i have 42 labels (each holds a day). Eventhough there are a max of 31 days in a month, sometimes days start off on a Wednesday or a Saturday, so there are 6 rows of 7 labels for placeholders (see the attachment).
In each label's onclick i have...
Anyone know how to hide the Column and Row headings in Excel. Meaning, remove the "A,B,C,.." column names and "1,2,3,.." Row numbers so that you have a pure grid-based output.
This is for a web based excel sheet generated by Access.
Not sure if this has been posted yet. Microsoft has released beta of Office 2007, this includes a new UI to many of the old office programs. For the time being you can get it here:
http://www.microsoft.com/office/preview/beta/getthebeta.mspx
Beta 2 of Internet Explorer 7 has also been...
Update Table Using a Conversion Table
Two Tables (one is a conversion table) examples below:
Tbl1:
Fld Location Conversion
Virg Post Office Virginia
Virg Government Virginia
Virg School Virginia
Virg Office Virginia
Virg VA
Mary...
In WinAPI you can select different multiple themes for dialog boxes. I was wondering if it was possible to apply YesNo buttons to an Exclamation setting.
For Instance:
MsgBox(text,vbExclamation & vbYesNo)
In an API I would just do:
MsgBox(text,vbExclamation | vbYesNo)
Not in any hurry on...
I have created a report based on a query that returns the following fields (from 3 different tables)
[Employee ID] [Employee Name] [Supervisor] [Salary]
It displayed just like that, but now we are trying to find the sum of the supervisor's worker's salaries. So I want to group all the...