Search results

Hi Alex, thank you for the reply. I get 424 - Object Required on this line: fileName.GetFileName(Me.txtOriginalFile) (But then again I haven't slept since friday night) I'll post back when I figured it out. Thanks again. Jamie.

Hello, It is 2am on a Sunday so please be nice. The form has a txtOriginalFile control. This is a hyperlink to a file at it's original location\folder. The record source's PK is in control txtMyPK. The following code works as expected and copies the file to the destination folder (myFolder)...

That is impressive! Thank you StarGrabber. That is exactly what I had in mind. And the added functionality of limiting the filetype is awesome. Thanks again. Regards. Jamie.

I don't mind the log file, and your solution seems to work fine. Thank you. I will test it for a while and post back if there are any problems. Thanks again.

Hello, I am using the following Module and Code and it works well: http://www.access-programmers.co.uk/forums/showthread.php?t=228573 The only problem is that the backend is password protected. So everytime I call... Call CompactBE ...it prompts for the password. I can ofcourse just...

Hey pr2-eugin (btw: thanks for your help with a previous unrelated post). Yes, the A2007 attachment control works well for me. The database will contain at most 50 records. The attachment field will hold one jpeg (id size pic of person), and maybe 3 pdf files. So file-size is not an issue for...

[SOLVED] VBA to simulate Acess 2007 Atachment doubleclick Hello. I would like to add a cmdButton to add attachments to the attachment field instead of the user having to doubleclick the field itself. Any ideas ? Thanks. Jamie.

[SOLVED] Windows Login User - not Database User Thank you pr2-eugin, you pointed in me in the right direction. In the Module there is actually a " Dim sUser As String" line which I simply changed to: sUser = fOSUserName The 'UserField" in 'tblAudit' now gets the WindowsUserName. Thanks again.

[SOLVED] Windows Login User - not Database User Hello, I am successfully using the following AuditTrial, and it works well for my needs: http://www.access-programmers.co.uk/forums/showthread.php?t=140387 In the field "User" in table "tblAudit", I would like to Log the Windows UserName...

Hello, Please help me with this if you can: - On "myFormA" is a ListBox named "lstMyListbox" (column 0 is primary key same as myFormB). - Another form, "myFormB", is a SingleForm(view) which shows records from a query. - On "myFormB" the PrimaryKey field is "txt_myPK". - Also on "myFormB" I...

Thank you. As RuralGuy said: "...your Click procedure needs to be Public rather than Private..." So it was the PUBLIC vs PRIVATE thing. Thanks again.

Hello. I am trying to simulate a mouse-click of a cmdbutton on another form, or call the Click event of a cmdbutton on another form. From Form1, I want to "click" a cmdbutton which is located on another form. Here's what I have so far: Form1 is Open. A cmdbutton on Form1 has the following...

Access2000 Hello The mainform is based on a query and also has a autonumber(prim key) field as well as several other fields. Several sub-forms on the mainform links to the mainform's autonumber field in a one-to-many relationship. When the user opens the mainform (with recordsgotonew), the...

[ACC2000] Hello, I am already using the mousehook dll which works perfectly well. In a long(vertically) Form, I have set the Scrollbars to 'Vertically Only'. I still want to use mousehook.dll to prevent scrolling records with the mouse, but I would like to be able to scroll the Window(form)...

Hello everyone, In Access2000, I have designed all my Forms with my own choice of background colour, Button colors, etc. As part of an upgrade to my database, I now want to change the background color of all the forms. Is there a way (maybe VB code ?) to change the color of ALL THE FORMS...

sorry about typo in TITLE (must read : return login name (AND DESCRIPTION) Hello, In my company we use the Employee's Employee-Number as a Windows login name. This is registered in the Domain along with the Employee's Real Name. So at the Windows(XP) login screen the user enters his/her...

Thank you. I like the idea of having the AuditTrail in a separate Table. This way I can easily generate my reports on the Audit. But that Module does not track NEW records. (only existing records that changes). I admit to being fairly novice with this. Can you please offer any advice on how...

Hello, In ACC2000, I am using the Module from this page... http://support.microsoft.com/default.aspx?scid=kb;en-us;197592 ... to keep an audit trail of the record. So, the table has a field named "fAuditTrail" and on my form(s), in that field's BeforeUpdate event, it calls the "AuditTrail()"...

@georgedwilkinson Thank you for putting me on the right path with Dcount. nz(Dcount("*","tbl_Personnel", "pers_name = '" & Me.txtpersname & etc, etc, etc, "'"),0) Having that at the end of my custom SAVE button's onclick, together with a vbYesNo works perfectly. Thanks again.

my db is huge! as in many many tbls,frms,reports,qrys etc,etc. and since i work for a gov. dept. i will have to strip just about everything. -they get very tense about the smallest of things :) but i will create a new db tomorrow and post it for us to play with. we only need 1 table with 5...