Search results for query: *

Just a guess - is the datepicker control either 'Locked = Yes' or 'Enabled = No' in the control properties?

The replies above are good technical answers that address the most likely cause of your problem. I am only chiming in because I have been running Win7 & Access 2003 on my primary development computer for about 3-4 weeks now and have not seen what you are describing. I also have a Win7 Access...

You could also check fields in Before Update and notify user they are changing an existing record. This won't stop them but does give fair notice. If Not IsNull(Me.txtEmpFirst.OldValue) Then If ((Me.txtEmpFirst.OldValue) <> Me.txtEmpFirst) Then 'they are changing the first field...

I have used: 'blnSuccess = FTPDownloadFile("YourHostName", "YourUserName", "YourPassword", "YourLocalFileName", "YourRemoteFileName", "YourDir", "YourMode") to pickup files from ftp sites. Now however, I need to set both Port and Security (Auth TLS) as well. I can pick up the file manually...

PHV - Prior to your post I got the routine to work by implementing the 'sleep' routine in thread705-1522673 which incorporates DoEvents as you suggested. A pause of 15 seconds and my zip and ftp ran fine. Thanks.

PHV - thanks for the response. However, I have further information. If I break the routine into two separate processes run by separate cmdButtons - (step1) Zip then (step2) FTP the file will go. I think the problem is that the routine is trying to Send before the file is ready to go. Any ideas?

thread181-1493416 I'm using the following code" Public Sub CreateEmptyZip(sPath) Dim strZIPHeader As String ' header required to convince Windows shell that this is really a zip file strZIPHeader = Chr$(80) & Chr$(75) & Chr$(5) & Chr$(6) & String(18, 0) MsgBox...

Thanks - I will work on that and see what I come up with. Thanks.

I would prefer to open the spreadsheet from Access, preprocess it (deal with embedded header rows) and then import to a table. Here is a rough sample COMPA DATE ACCTNUM LOC PARTNUM QTY COST xx/mm/yy 12345 B1 9876 12...

Unfortunately I'm stuck with the Excel file as is - it is prepared by a large national company we do business with. I need to be able to recognize each embedded header (row) that starts each chunk of data (as I described above). How would I recognize each header in the import file? Or...

I need to import an Excel spreadsheet into an Access table on a recurring basis. The spreadsheet (prepared by another company) has multiple headers embedded in the rows - the headers basically break the data into categories. For example the first header at Row 1 might be Cars (and have...

See thread 702-1517283 in this Access Forms Forum

Here is the solution - if you need more information let me know. http://www.groovypost.com/howto/microsoft/outlook/fix-outlook-cant-create-file-attachment-error/

Thanks - I am still working on it - if I find a solution I will let you know.

Did you ever figure this out? - I am suddenly having the same problem. Thanks.

Remou: I like your suggestions and will study them more carefully in the next day or so. Thanks.

I appreciate the comments so far. To keep the discussion going - some valid issues have arisen. You could have 4 Tomato Paste items under 'Canned Goods - Sauces' Category Item A: 8oz Tomato Paste - Low Sodium Item B: 80z Tomato Paste - Low Sodium Item C; 10oz Tomato Paste - Low Sodium Item D...

Looking for best way to approach this concept of keeping track of 'related' items that are substitutes for each other. Simple example: You have a Product Category 'Canned Goods' and within that you have 3 items that are legitimate substitutes for each other (e.g. Vendor_1 8 ounce Tomato Paste...

Thanks - ASCII 133 worked perfectly. As I mentioned I did not want to change settings in AutoCorrect as someone can change them back.

I have a text field that ultimately gets exported to another application. If the User enters 3 consecutive periods "..." Access autocorrect turns them into what appears to be a vertical pipe "|". I need to trap for the occurence of "..." or "|" but have not been successful using InStr. I...