Search results

Oh...that makes sense is to pull a file with any extension not text... Is there anything I could do for a file with no associated program. Like can I put wildcard character to find the file name tha begins with etc..

Hi, I need some assistance...I created a command button for the user to press and import a file. This works great but then I had to involve IT in my company and I am getting is headache... IT function is to everyday automate the process by taking the file from one system and dumping it into the...

Thank you for your help. At this point I created the query with the fields that I want to merge into the form. So, I need to figure out how merge the data so when the documents the data is already pre-populated into the form.

VBA is very limitted Right now I am using the letter merge function by going into word and picking the file and that opens the query attached to the documents and merges data. I want to eliminate that step I want the user to do it directly from the database and open transfer the data. I...

Hi, I have several vendor forms that must be completed each asking for the same data but all have their format. I would like to do is in a form I would like for the user to pick the form and put the ID # of customer. Based on that run the query and merge the data to a word, pdf, excel...

Hi, I am trying to import a text file using my own Impoort Specification the DoCMD transfertext works but it gives me to many blank rows because the way the report was created. I would like access to get the file and appy the code below and so that all I get is rows where ":" is listed and...

Thank you again, this works great.

Thank you, this might work. I am going to incorporate the table but i am confuse about the other two table the index and related table.

Question, I created a database that holds information on authorizations we obtain. What I would like to do is scan any paper works related to that specific record and create a link to the folder where I am holding the scanned document. I also would like for the person working the case to...

Hi, I need some assistance, I created a searched form that opens a query with the records that I want. What I would like to do is to be able to double click on a field an open a form with the full details of that record. Is this possible on a query I don't see an Event option on the fields...

I would like to create a filter on a form that will show records based on my selection from drop down box (combo box) and show the data in a subform in Datasheet view that I query. How do I do this? Please help thank you.

I think I found the issue is because I had generic/text printer as my default. I took it off default and is working fine now. Oh well, I need a new computer anyway.

Hi, I am having a problem for some reason I lost the fonts options when I try to create a report. Instead of having the options of full list different fonts I only have three options Device Font 10cpi, 12cpi, 14cpi. I don't know how this happen and this is the second time. I wasn't able to fix...

Thank you...this work great...

Hi, I have several tables and I created fields to capture when records is created and changed by date and username Before Insert and Before Update. What I would like to do now is keep track of old value on separate table. any assistance will be greatly appreciated. Thank you

Hi, I have Report dialog box form where we could choose multiple reports to preview or print. I created a Pivot table report it looks great when Preview but in the option to print I would like for the file to be transfer to excel in Pivot Table format. I got the file to transfer but it does it...

Thanks, I think this work...I will group by Max Date and then I could pull expired applications.

HI, I have a table that keeps record of applications with expiration dates for applicants. What I would like to do is query expired applications? but there are some multiple records per applications that have expired or are current. Which is ok?? We want to keep track of everything. How do I...

Thank you all for your help! I got as far as getting the Message Box but it won't go to the control Field. It gives message "an expression you entered is the wrong data type for one of the arguments" If IsNull(Me.Form![Z_VerificationInsuranceForm]![Z_Authorizationform]![Insurance...

Need some assistance!! I have a main form that has a subform that will be use to verify insurance information. I have instructed the staff once is verified to indicate in the field [Insurance Verified] "Yes". I want for a msg box to come up when I click the close form if the field is missing...