Hi,
Sorry - I guesss that wasn't too helpful. Before you do anything, I suggest making a copy of your database as a backup. That way you can fool around without needing to worry about the safety of your data. This is the safest way to work on your database, I'd reccomend it as general...
Hi -
You can get the value of any column in a combo box like this. Note that indexes start at zero, so the 1st column will be 0, second 1, and so forth.
[Forms]![YourForm].[ComboBoxName].[Column](index number)
For the AfterUpdate on your combo box just enter
Me.[Ratetextbox].Value =...
Hi -
In what context do you need the query - do you want it to appear when a user hits a button, open as a recordset, etc? Somebody should be able to help.
- CJ
Try this -
Dim strUser as String
Dim strpath as String
'Get Windows username
strUser = Environ("USERNAME")
'create string for path
strPath = "C:\Documents and Settings\" & strUser & "\My documents"
'do whatever with strPath
Good luck, CJ
Hi -
If you have a 1:1 relationship between members and schools, you could write a SQL statement pulling all the data from the different tables together, and then paste that SQL into the form's Record source (you do need to use the SQL rather than an actual query). You can then design a...
Hi -
A for...next loop sould do the trick. I'd suggest fooling around a bit with loops before using this to reach all users, but here's the general idea...
This does assume your send command is OK...
Good luck - CJ
'---------------------------------------------------
Function Send
Dim...
Hi -
You could use the InStr function to look for instances of " " (double space) and then the Replace function replace them with " " (single space). Something like this (I haven't tested it, but you get the general idea)...
Function RemoveExtraSpace(YourString as String)...
Yikes - I agree this is a very scary way to do things. If you have absolutely no choice, you can use a For...Next loop like this
cmdYourButton_OnClick
Dim intReplicate As integer
Dim i As integer
'Get total times to repeat process
intReplicate = Me.<TextBox with number>.Value
'Add new...
Put this line in the form's OnOpen event and again in the box's AfterUpdate event. There may be a way to get it into a single event, but I don't know what it is.
Me.YourComboBox.ControlTipText = Me.YourComboBox.Column(index for whichever column has the description you want to use)
'remember...
Now I am truly stumped...sorry! Fooled around a bit with the InStr function and couldn't produce an error. You could try submitting another post with a desperate-sounding title.
Good luck,
CJ
Hi,
Access has a conversion utility in Tools -> Database Utilities -> Convert Database. You have the option of going to either a newer or older version, although I've only used it going from older to newer. One problem with conversions is that an error or inconsistancy in a single form...
Not sure, it looks OK to me...I'm stumped. There are a few functions (in theory, at least) acting in concert here, so you might be able to pin down the souce if you try slowly building the statement. In other wirds, try InStr(1,[NAM1],", ") and if that works, try...
Hi
The quick explanation of how to do this is to concatenate everything to the left of ", " with everything to the right of ", ". One way to do it is use the InStr function to get the character position of ", " then the left/right functions to get everything to...
Could you use a SQL to pull all the desired data together into a single source, then export that?. You could either do the work as a stand alone query or use VB to program a new Query Def then export it using the transfer spreadsheet method.
Good luck,
CJ
Hi,
If the fields are different, or if a field has one data type in Excel and another in Access that can screw up the works.
For what its worth, I've found that you get a bit more control over the whole thing if you import excel as a new table (play with any field names/data types, etc)...
Hmm,
Have you experimented with using the user's windows logon to detect who's in the db (you can get it without any user input)? You could set up a table where the user's last set of parameters get written to a record with the user's logon upon exiting the db (each user could have 1 record...
Access will gray them all out if you don't have a default value set (aggravating, yes) even if it appears unlocked, enabled, and ready to go. Could that be it?
CJ
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.