Recent content by peryan77

How would I go about allowing a user to create a folder in a given directory, but only if it does not already exist?

MV040603.CDX MV040603.DBF MV040603.FPT I tried to open the above DBF file with access and I get an error saying cannot open associated xbase memo file. All the files are their. I can open it in excel, but certain fields (prob those memo fields I need) are scrambled up. Does anyone know the...

Thanks soo much it worked. I did not know about this and I have been using access for 4 yrs. Never stumbled upon this dilemma before. Patrick

I have a combo box on my form and when I select a record from it (employee name) it goes to matching record in subform. However, i get an error when i select an employee name with an apostrophe in it. Syntax error, missing operator in expression. Here is my code..it works fine with all the...

I could of sworn I posted a thank you and gave u a star. Wait I did, look above, I said thanks, it works great. I have not used the second posting of your code. I will try and implement it when I have more time. They have me doing a million and one things all at once. Thanks again.

It does not have this property. Object does not support this property or method.

I am trying to set the DTPicker control to current date. Here is my code: Dim CurDate as Date CurDate = Date() Me.DatePicker.Value = CurDat The error I get is that the property is read only.

Something like this... Sub ADOFromExcelToAccess() ' exports data from the active worksheet to a table in an Access database ' this procedure must be edited before use Dim cn As ADODB.Connection, rs As ADODB.Recordset, r As Long ' connect to the Access database Set cn = New...

About 5 months ago I saw an access database that showed how to add a file to the database without inflating it. Does anyone know how to do it, or possibly know what site it was located on?

Thanks a lot. I will use all the methods I can. The database is quite small now, but will grow as I continue to add more features and data.

I have a split database on the network, unfortunately it is too slow. Are there ways to speed up the connection?? Some users access it using WAN. Unfortunately, they will not let me create a SQL Server Database.

Nevermind I figured it out.

What Event would I use to initialize my code right after the person changes the date in this control? I do not see a change event for this control when I look under it's properties.

Thanks Cajun, it works great.

I didn't think it was possible either, I really rather stay away from renaming all those controls, it makes it harder to go back and recode and errors when you lose track which field = what control. I presume you can use TAG property and just embedded another if statement in the code? I will...