Search:
Type: Posts; User: babbelut
Search:
Search took 0.04 seconds.
-
Hi all,
I have the following lines in my xml:
<button idMso="Copy" label="Copy" size="large"/>
<button idMso="Paste" label="Paste" size="large"/>
I don't want the normal images but a custom...
-
-
Hi,
this is a tutorial how to make a custom menu, but not with vba.
My menu is fine, I just need to change the text of some menu items on the fly (with vba)
thanks
-
Hi All,
is it possible to change the menu item names in Access 2000 (with vba)? I can not find how...
tx!
-
Hi,
I want to know how I can find out (in vba) if a text (caption) exceeds the width of a textbox or command button?
Ofcourse I can see this on my screen, when the text is not fully displayed,...
-
This gives me the access version of the installed access application.
I need the access version of the opened database.
-
Hi all,
I am writing a vba-function to check in which version an access database was created/saved...
I use: currentproject.FileFormat
This is working with all versions except access 2010:...
-
No, I do not want to change the macro that needs to run.
I want to change the name that is displayed in the menu
-
Hi,
I already found the tutorial for working with commandbars, but i cannot find how to include all the things that are in the macro...
http://i42.tinypic.com/o8v1ns.jpg
How do I include...
-
-
Hi,
This does work but renames the macro. I need to rename the "macro name" field in the macro (when goïng to edit mode)...
-
I prefer vba code, because the name depends indeed on the user input...
-
Hi all,
I have 3 macro's to create the menu in my access-form.
MACRO 1:
DoCmd.AddMenu "&File", "M_File", "File"
DoCmd.AddMenu "&Edit", "M_Edit", "Edit"
MACRO "M_FILE":
-
Hi all,
i need to loop through all Forms and Reports (opened and closed) but I cannot find how...
In every Form and report I need to loop through every control.
Can someone help me please?
...
-
The function is written in Form_AfterUpdate() from Preferencessub2 (another subform from Prefs).
-
Hi all,
I have imported Tables, Forms, Queries and Macro's from a access-2000.mdb to another access-2000..mdb.
After the import, I get:
"Compile error: Method or data member not found"
on...
-
-
-
I have a form with a calendar-control on it.
The source of this calendar is the field "DATE", which is in the table "LOGS".
The default value of field DATE in table LOGS is Date(), so when I add...
-
OK, I found how to disable the ribbon items...
Only "file" is visible now and under file-> Add-ins I can find the items I created in the xml...
Why are they displayed under add-ins here?
How can...
-
I've created a customized ribbon, which is displayed perfect under office 2007.
In 2010, the items are also visible, but are under "add-ins"...
I want to disable "file", "home", "create",...
-
In my form_open, I have:
If Val(SysCmd(acSysCmdAccessVer)) = 12 Then
Me.Properties("RibbonName") = Me.MenuBar
End If
but in office 2007, when I start the form, i get:
can't run the...
-
When I use the code, no error, but also no changes...
I use this code in a subform to disable a control in another subform. How can I make this possible?
thanks
-
I have a form with several subforms on it.
When subform A (Continuous Forms) is empty, I want to disable a command button on subform B...
I already have (in the vba code of subform A):
...
-
-
Function (ID, field, truevalue, falsevalue)
Set RS = DB.OpenRecordset("SELECT name, " & field & " FROM table WHERE ID = " & ID & ";"
While NOT RS.EOF
' a way to save names and fields(values)...
-
In Access I have a table with this structure:
A : 2
B : 6
D : 15
Z : 2
...
How can I keep this values in a variable in vba? An array seems not to be the way, because myquery("A") does not...
-
Hi all,
i want to build a query but i cannot find the correct one...
Situation:
Table one has "ID" and "value"
example:
ID= A and value= blue
-
Hi all,
When you have a lot of code, functions and subs in vba6.5, it's very difficult to read the structure and code of the form...
Is there a possibility (option/add-in/...) to...
-
where in VisualBasic6 can I find the properties of the form (and all the subcomponents)...
When I would have those properties I could change/replace/resize the form.
Is there a simple way to do...
-
Hi,
I have made a tool in vb6 in two versions: a fullscreen and a laptop version.
Now the problem is, when the code changes, I need to change it two times...
Is there a solution to this? There...
-
I tested the connection on another switch and it was very fast... so indeed the reason is a very slow network (So the switch must be checked). I will keep the connectiontimeout-setting offcourse.
...
-
Tool seems to work now, can you explain me what the connection Time does exactly? :s
-
mySQLconn.ConnectionTimeout = 30
ConnectionTimeout = 'ReadOnly' ...
-
Hi,
I will try your code tomorrow. But the form needs to work 24/24 7/7, so does connectiontime solve this?
The refresh reloads a listview with (new) information from the SQL-db.
-
This is the screenshot of the error:
http://oi53.tinypic.com/2hg8z08.jpg
And here I call this method:
Private Sub frmSHF_Load(ByVal sender As System.Object, ByVal e As System.EventArgs)...
-
I have several msgboxes to check where the error is...
Private Sub loadSQLConnection()
mySQLconn = New SqlConnection(mySQLStr)
Try
mySQLconn.Open()
Catch...
-
No, because in normal debugging I don't have an error. And when installing the tool on all the pc's -> still no error.
But just one PC is giving this error when running the tool... don't know why,...
-
No,
It all goes very fast. When I open the tool everything loads very fast (form is available in a few seconds), but when it wants to reload, this does not work on 1 pc...
-
Yes, I keep reference to the same connection.
What do you mean by open all the time by chance?
|
Click Here to Expand Forum to Full Width
|