Recent content by Tiro Cupidus

I haven't used AppActivate before, but that should work fine.

Try search Access help for "Union Query" to see if that's what you're looking for.

I shortened the code up a bit. Are you intentionally nesting the If statements this way? Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Me.FinalRecert_subrep_01.Report.Text29.Visible = False 'LAN Me.FinalRecert_subrep_01.Report.Label30.Visible = False 'LAN...

You need to bind your combo boxes to your text column instead of your ID column since you are storing text values in your Violations table. However, it would be better to store the IDs in your Violations table instead of text. If you do that, your combo boxes should be fine. Edit: Even better...

I'm not sure about your error, but for your last question: CurrentDb.Properties("AppTitle")

You can use the File System Object to transfer files into a specified location (attachments subfolder), and use a table to store the record ID and attachment name. This requires a good amount of familiarity with VBA to accomplish, but it's the only way I know of.

Ah, well this is an HTML issue, not MS Access. :P I don't think there's an easy way to make something blink in Internet Explorer, so I'd recommend just changing the color or other aspect of the PC you want highlighted. To accomplish this, you'll need to use Javascript or VBScript. I found an...

Select "[Event Procedure]" in the form's OnTimer event, then click the "..." button next to it. In the procedure that comes up, put something like this: Me.ControlName.Visible = Not Me.ControlName.Visible That should give a blinking effect for whatever ControlName is. If you want to use colors...

You could make it blink by using the form's Timer event and the Timer Interval to however many seconds * 1000 you want it to blink. In the code, you'd set the fore/back color for whichever control you want to blink. I would make it subtle, as blinking can be annoying.

You could try using Type Conversion Functions when you send the data to your bookmarks. Example: .Item("quoteMaterialCost").Range.InsertAfter CCur(strMaterialCost) I don't know if it will work, but it might be worth a shot.

I'm not sure why it's not sorting, but one way to fix it is to assign the Record Source of the form to a query instead of the table. In the query, you can specify to "ORDER BY surname, firstname".

Something like this: Dim NumRecords as Long 'Or Integer, Byte, whatever fits your data Const RowHeight as Integer = 100 'Change to fit your needs Dim SubformHeight as Integer Const MaxSubformHeight as Integer = 2000 'Change to fit your needs NumRecords =...

All of your training data is stored in a single table? Or is it set up in three tables? Like this: tbl_Trainees Trainee_ID TraineeName etc. tbl_Training Training_ID TrainingName TrainingNumber Department etc. tbl_TraineesToTraining Trainee_ID Training_ID TrainingDate

It sounds like you should be able to import the request list into a table in your database, then use the Find Unmatched Query wizard (New Query) to walk you through getting the list you need. If you want the results to automatically go into your main table, you can change the query type to "Append".

The script can be stored in on a server, but it will run on whatever workstation runs it. It would run when the hidden form opens. If it reads that the variable is false, the timer loop would exit and finish running the script, closing the database. When the hidden form is closed, you can end...