Search results

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"...

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

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

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...

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

Hello All, Is there a way to retrieve the very last entry to a table (via a query) without passing a value to the query. Lets say I have a table Pets ID desc ============== 1 Dog 2 Cat 3 Lizard For example lizard was added last, is...

Hi All, I have created a query that I want to run from a form (thus far no problem). Where I do have a problem is that I want to take the contents of a variable and use it in the query. I don't want the input box asking for the value. I hope that I have made myself clear. Cheers, Aaron

Hi all, I am basically trying to concatinate a currency symbol to the value of a textbox BEFORE it is saved and I am being hit with the "Run-time error '2115'" Here is the code: Private Sub amount_BeforeUpdate(Cancel As Integer) Select Case strCurrency Case "CAD Dollar"...