Search results

No doubt!

Hello, Thank you for your reply. Unfortunately report will not do the job for me for I have controls in the form that requires input from the user and I don't think a report will give me that capability (unless you tell me otherwise). This form/template is going to replace our Word document...

Hello, I have a 3 page form that is a copy of one of our Word document. When I do a print preview: On page 1, some of the data are being cut-off On page 2, half of the data are being repeated in page 3 Therefore, the beginning of page 3 is in the middle of the page Frustrated

Cognitive Hourglass On...?????? Speak Up!!! in English please!!

Hello again Ian, Unfortunately I have nothing to do with the documents being in Word. I just started working for the company 6 mths ago and they have this system set-up for years. However, I have in process recreated the document using a form(template) instead of a report because there are...

Hello Ian, Thank you for your info. At least it's something. I did ask the boss about somekind of listing and there is none. Question for you though. I assume you can't have these docs in the database as reports? meaning? Any good jokes for me lately? [This message has been edited by...

Hello! This may sound an over-kill but hoping it could be done via VB code. I have fields in my tables that are being referenced into many of our Word documents. I need to find a script within Access that would open the file(s), refreshes, saves and closes. Would mean that for the future I...

Hello! Thank you for your reply. I posted this question in another site/forum and that's exactly the same comment received. Thanks again for the feedback.

Hello! Help! Can anyone figure out what's the error in this code. I get a compile error/variable not defined and to be specific, points to this line of code. The NameToSearch turns black. ' Search for the name that the user entered. For RecNum = 1 To LastRecord Get #FileNum, RecNum, TmpPerson...

Hello Chris, Once again thank you very much for the suggestion. Exactly right. The "space" was the error. Happy Friday and have a good weekend!

Hello! I have a form that has a text box and when you double click on the text box, download will happen automatically from textfile but instead I keep getting a compile error / syntax error. Can anybody figure out what is the syntax error in this code?. The line "On Error GoTo readAllFile...

Hello my friend across the water! Wondering if I will ever hear from you. Didn't know how long I have to wait until you feel sorry for me. Thanks I will take up on the offer. BBFN Trini

Hello!! I thought you deserted me. Thank you! Please make sure and check back I will get back to you if I run into another problem Thanks

Hello! I have 2 forms frmSource and frmDestination. On frmSource I also have a textbox called AssyPartnumberVis which are concatenation of values from 3 listboxes. This the code in the control source of txtAssyPartnumberVis: ="A" & [lbxCuttingTools].[Column](0) &...

Hello and thank you for replying to my question. Yes that's exactly what I meant. And also Yes that I tried to repost then decided to delete it because I thought that Chris RR would reply back to me. I didn't realize that you were in the process of replying to my question. I apologize and...

Hello Chris, Once again thank you for your reply. To answer your questions: On my frmSource, I have 3 listboxes where RowSource are coming from 3 different tables. Each of these listboxes included ID # and Partnumbers columns although I have the width set to 0 (zeros). On the...

Help anybody! I have 2 forms: frmSource (data came from 5 tables and consist of textboxes, comboboxes, listboxes, etc.) and frmDestination. I would like to add another field in the Destination table called AssemblyPartnumber. The system requires that we generate a unique partnumber Example...

Hello Chris I am going to try to answer your question as close as I possibly can. I have a very complicated database. Believe it or not I have no relationship set up. You are absolutely right. This form/table was generated by Access when I passed the data into frmDestination. The intent of the...

Help anybody! I have 2 forms: frmSource (data came from 5 tables) and frmDestination. Question: frmDestination is setup to have an ID field (is that necessary?) Is this possible to replace ID field to become Assembly Partnumber instead? For every record collected from frmSource will be...

Hello Norm, Thank you very much for your reply. Could you suggest a book in particular? If not, just the same a big Thanks! : ) Trini