Search results

I found out the issue. Was a data source that was missing. I wasn't told about this one and now that I have added it, it is working successfully.

When I test connection it completes successfully. I have made sure it is the same as it is on the computer that can export the database without any issues. I am completely stumped.

Hi, I have inherited a two Databases which is pulling sales data from our SQL Server and then exporting the data into a text file. Now one database works fine but the second one doesn't. It is returning error 3146. Marco Name: Export Routine Action Name: ImportExportText Arguments: 3...

Thanks for your reply it has worked but the other way to what I wanted it too. By that I mean the fields I would like disabled when the form is in add mode are enabled but when I want them enabled in "normal" mode they are disabled. Any ideas?

Well I have a switchboard that opens it in add mode only and then I have a command button within a password form that opens it up in for a better word normal mode (as if you click on it with in the main menu). Those would be the only way that it would be opened.

Hello, I would like too know if it is possible to code a form so when it opens in add mode certain fields are disbaled and if it opens in edit mode then all fields are enabled. Many thanks,

Ok man. Well thank you for your input.

Havent even tried to edit it if I am honest. Tho what I do have to say is when a record is created when a member of IT go in to edit the record to assign it too a member of the IT team the original username field doesn't get overwritten which I was glad about.

TBH man I don't know I have just gone thru the steps that was on a website and it works for what I need it for. If the time comes where it doesn't work anymore for whatever reason then it would be time to change it but as now it does work.

Hi guys, I have successfully managed to do this using the following code Private Declare Function apiGetUserName Lib "advapi32.dll" Alias _ "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long Function fOSUserName() As String ' Returns the network login name Dim lngLen As...

Cheers man will have a look now.

Good morning all, After some great, great help on this forum yesterday today I have another issue I would like some help with :). I am just tweaking my database and I would like to add some validation. I have a userID field which will currently allow the user to enter there name, but I...

Thanks for your reply and help man, yourself and G37Sam and sorted it for me. Thanks a lot much appreciated.

Spot on mate, spot on thank you for that great help.

I will hopefully try to brief you as too what exactly happens and I hope it can help you help me :). When I enter a LogNumber into the text box on the form then hit the Search button I have a window pop up saying: You must see the dbSeeChanges... blah, blah, blah. I then proceed to the...

What would I declare rs as and also how would I fit that line of code into my exisiting code? Cheers,

If you look in my OP I have said what the error code is and what is highlighted when the debugger runs. My problem is I don't know what to change :/. Cheers,

Private Sub Search_Click() Dim db As Database, rcd As DAO.Recordset, lngCount As Long, intRtn As Integer Dim strWhere As String strWhere = "" If Not IsNull(Me!txtLog) Then strWhere = "[LogNumber] Like " & Chr(34) & Me!txtLog If Right$(Me!txtLog, 1) = "*" Then strWhere = strWhere & Chr$(34)...

Good morning all, I have a form which acts as a search form to find records within the database. The database was created in access but has since had the table upsized to SQL 2005. The Search Form was working but now I get the following error displayed. You must see the dbSeeChanges option...

Thank you for the reply Galaxiom I have done as you have described above but another error now exists. Don't you just love VBA :/ The error now being displayed is: Run-time error '3078' The Microsoft jet engine cannot find the input table or query '[tablename]![ID]=7'. Make sure it exists...