pdebaets
Last Activity: Aug 22 '12, 04:28 AM
Joined: Mar 22 '08
Location: Los Angeles
-
This info may help: http://support.microsoft.com/kb/269495 -
You are doing string comparisons for all fields in your SQL statement. Is emp_Id a text field? If it is not, then that could be causing your problem. Try
... WHERE emp_id = " & rstReplacement! emp_id & _ ...
I always surround date values with "#" characters. Ex.: #1/1/2011#. Try that if your problems persist.Leave a comment:
-
See the 2nd example above "Dynamic report designed to be used with Crosstab Queries". This example does not open the report in design view, and should therefore be compatible with .accde files. You can adapt it for general use with any type of select query.Leave a comment:
-
Try
Code:sum(iif(instr(1,RDesc,"AM ")+instr(1,RDesc,"PM ")+instr(1,RDesc,"Half") > 0 , workdaysabsent/2, workdaysabsent))
Last edited by NeoPa; Sep 26 '11, 03:01 PM. Reason: Please try to remember that [CODE] tags are not optionalLeave a comment:
-
I don't think that's a valid path. Try
Code:path = "v:\scc-e\irg\Monthly SAP\"
Leave a comment:
-
Welcome to Windows 7. You'll need to be signed on to an Admin user windows account to write to the Windows system folder. I'd advise against it. Instead, write to a folder that you're allowed access to. Create a "well behaved" application, and write to "%programda ta%/MyCompanyName/MyApplicationNa me" or "%appdata%/MyCompanyName/MyApplicationNa me".Leave a comment:
-
Put this code in the combo box AfterUpdate event procedure:
... where "MyTextBoxContr ol" is the name of your text box.Code:MyTextBoxControl.visible = True
Leave a comment:
-
I don't think you're going to be able to rename the back-end file if it is open (I.e.: if someone is connected to it from a front-end). You may need a utility application that does the renaming.
You can find the back-end full path by getting the connect string from a table that you know is connected:
...Code:dim MyConnectString as string dim MyFullPath as string MyConnectString = CurrentDB().TableDefs("MyTableName").connectLeave a comment:
-
If your record id is a text field, you'll need to surround Me!MyRecordID with chr(34) like so
Where MyRecordID is the name of your unique record ID field.Code:DoCmd.OpenForm Me.Name, acPreview, , "MyRecordID = " & chr(34) & Me!MyRecordID & chr(34)
Leave a comment:
-
You can use the path from your CurrentDb().nam e to serve as part of the path to your pictures. The function below will return the path from a full path and filename string. Just pass it CurrentDb.Name:
...Code:Function xg_GetFolderFromFilename(pstrFilename As String) As String Dim Marker As Integer Dim strRtn As String 'Dim intpos As Integer Dim i As Integer On Error GoTo err_section Marker
Leave a comment:
-
Try this:
Code:sql = "select IncidentsResolved.Severity,count(IncidentsResolved .Severity) from IncidentsResolved WHERE ((IncidentsResolved.[Arrival Time] >= #" & sdate & "#) AND (IncidentsResolved.[Arrival Time] <= #" & edate & "#)) GROUP BY IncidentsResolved.Severity"
Leave a comment:
-
Try putting a DoCmd.Maximize in your form OnActivate event procedure.Leave a comment:
-
What are the errors you get when you enter data in the tables?Leave a comment:
-
Have you considered securing and encrypting your database back end?
Here's a book that might help: http://www.amazon.com/Microsoft-Access-Database-Protection-Security/dp/1590591267
If these are not sufficient, then you may want to consider using SQL Server.Leave a comment:
-
Try:
DCount("[Folder_Num]", "tbl_Scan_Index ", "[Folder_Num] = " & folder)Leave a comment:
-
Very nice calendar, ADezii. Thanks!Leave a comment:
No activity results to display
Leave a comment: