Search results

What's the setup, is the database split FE/BE, I'd suggest a SQL server BE and you'll have no problems with data entry and multiple users using forms bound directly to tables. David

There are a few things that don't look right to me strSendTo = rec2("Email") strTo = rec2("Email") should be: strSendTo = rec2.Fields("Email") strTo = rec2.Fields("Email") olItem.Body = olItem.Body & rec("txt") & Chr(1) should be: olItem.Body = olItem.Body & rec.Fields("txt") & Chr(1) If I'm...

Adam, yes as Ling has described above, if it errors on the function call (pass value by reference), try Me.TargetTextbox = cleanStr CStr(Me.TargetTextbox) David

why do you need to check if it could be null, can it ever be null? And if the "LastLogInDate" is < today, do you need to perform some other event(s) David

try DCount("OracleID", "TblEmpAb", "[OracleID] = '" & txtOracleID & "' AND [AbStart] = #" & Me.txtAbStart & "#")

It is possible to have a table in Access that is linked to range of cells in Excel, this would allow you to query the data in that range. When you say "then populates the associated cell data." what do you mean exactly here? David

Does the FE app have anything written into it to change the size on the screen ie adjust the resolution David

what are the field names in your table [Final Data], you need to refer to those in your INSERT statement SQL = "Insert into [Final Data](Field1, Field2, .... etc) values ( '" & Me.Month & "','" & Me.Week & "', .... etc) ensure you list the field names and values in the correct corresponding...

If the image is to be the same for each email, then you could solve this simply by using a template and instead of Set objOutlookMsg = objOutlook.CreateItem(olMailItem) use Set objOutlookMsg = objOutlook.CreateItemFromTemplate(olMailItem) where olMailItem is a variable that holds the...

Baba, you could try creating a test blank database to check LAN connection. Paste this code into a module. This is basic code to connect to a SQL server database without the need to set up a local ODBC connection. Edit the variables to suit and run it and it should just link the one table...

azo, are you recording employee data in a database here or something else David

I think you need be able to reference the 2nd database's application window, the code docmd.runcommand acCmdAppMinimize I believe will always relate to the first database as that is the active application. Try looking up hWndAccessApp and hWnd I've never used this before, so can't really advise...

You need to check for IsNull on the DMax, if no record satisfies criteria or contains no records, DMax returns Null Dim warrantyCheck As Date If Not IsNull(DLookup("bar_code", "tbl_Module_Repairs", "bar_code = '" & Me.Bar_Code.Text & "'")) Then If IsNull(DMax("[complete_date]"...

Yes, use the method below which is a classic way of handling recordsets. Dim db As Database Dim Rs As Recordset Dim sqlStr as String Set db = CurrentDb() sqlStr = "SELECT My_Var, My_Value FROM [yourTableName]" Set Rs = db.OpenRecordset(sqlStr) Rs.MoveLast Rs.MoveFirst If Rs.RecordCount >...

try setting up a generic login/password in SQL server, assign public and sysadmin roles and map this user to the SQL Azure database. Then edit the connection string to include the uid and password David

do you need to open the file after selecting it via the filedialogue box? David

Do you have the SQL Server Native Client installed on each PC, if not you could use the basic SQL Server driver in the connection string. If the PC's do have it installed then you need to check if the connection string specifies a user id and password, may be worthwhile creating a generic SQL...

what is it that determines the rowsource for the list box. If there are conditions you can test to determine the rowsource, it is possible to set the properties for the listbox using vba like this: If condition1 = True Then Me.Listbox1.RowSource = "query1Name" Me.Listbox1.ColumnCount...

how is this data currently held? David

how are you connecting to the database with PC's on the LAN, post the connection string David