Search results

Thank you very much :)

Hello All, In the code below I am trying to pull a specific value from the DB but is appears to ignore the variable I am sending the RS. Sub GetUserdetails() Dim rs As DAO.Recordset Dim stSql As String Dim strGreeting As String Set rs = Application.CurrentDb.OpenRecordset("tblUsers"...

Great - Thanks, it really helped!!

Hi, I have never heard of this function. Is there some material where I can see how to impliment this? Public Function getWinUser() As String getWinUser = Environ("UserName") End Function What referance needs to be used? Cheers, Aaron

Hello All, I am running my Access DB on Versions 2000, 2002, and 2003. I am trying to get the windows username via apiGetUserName, which apparently requires Microsoft Access 11 Object Library. Is there any way to make this iead work on the different versions? Regard, Aaron

g r e a t !!!!!!:d

Hello All, This is a bit embarrassing, but I have accidently shut myself out of my project. In the Startup menu, I have disabled all the options and cannot open the project for editing. Is there a way to get back into my project. I appreciate any help given. Best regards, Aaron

Let make start at the beginng, I have confused the situation. Here is what I want to do When my form is loaded I have a combo box that is getting its content from a table called tblTeams. Keyfield => fldTeamId What the user sees and choses => fldTeamDescription When the user choses a team I...

Yes I did, I use this for queries that don't need parameters that chage or to link them to tables. My problem here is to send parameters at runtime

I am using access 2003 but part of the problem is that it will be run on pre 2002. I do not know how to bind recordset and assign it directly as the source of my combo or list combobox. Cheers, Aaron

Re: Passing variables to queries formerly Combo Question Hi RG, The Select is put together at runtime and put into the variable stSQL. In VB I know how to populate a combobox but VBA is different. Since I am using Access, it would be best to call a query and pass it the variable, but as I...

Hi, To be perfectly honest, I would rather use a query. The problem is that I don't know how to send a parameter to a query. This would probably be the best way. Any Ideas? Cheers, Aaron

Hello, I know that this has probably been asked a million times but.... In VB, I would have done the following, but this is not possible in Access MyDB.Open CurrentProject.Path & "\" & CurrentProject.Name rsDB.CursorLocation = adUseClient rsDB.CursorType = adOpenDynamic rsDB.Open...

Sorry guys, I've solved this myself

Hi Folks, My friend used a wizard to create a form that allows the user to run a report based on a query. The report is created in an excell format and added as an attachment to an e-mail. I am trying to fiure out where I can change the name of the file that was created. any idea what to look...

Hi All, I am opening one form (Form B) from within another form (Form A), I would like to stop all the followin code in Form A from being processed until Form B is closed. Any tips? Cheers, Aaron

I am sorry but I have no Idea what you mean by this. I have a form that has one label or textbox that has a numerical value, for the example I have provided it is a label with the numerical value of eight. when the user preses the button on the form, the following code is run. Query the powers...

Hi, I have been trying to figure this one out. I am attaching the DB with the report I want the button on form1 to display. I would like the value inthe label to be passed as a parameter to the query behind the report. Cheers, Aaron

Hi, After making the following changes: Private Sub cmdPreviewTodaysActions_Click() Dim stWhere As String On Error GoTo Err_cmdPreviewTodaysActions_Click Dim stDocName As String stDocName = "ShiftWorked Query" stWhere = "[ShiftAdminId]=" & intPresentShiftId...

Hi John, It certainly helps, thank you very much:D