Search results

Thanks for that, Juan. One feels a bit of an idiot when reminders to search appear, especially after searching. After searching for copy file and receiving no satisfaction, I posted; after ghudson's note, I found many references for FileCopy!! On a positive note, this site has assisted me...

Thanks ghudson. I did search this forum, high and low -- and I apologise if I offended, but found no reference to this elsewhere .... BTW, this worked a treat!

Greetings: I have a database where I collect photos of items, and text of said items. The photos are not stored in the database as OLE objects, but are linked to a record and stored in a separate folder. This is working well. My challenge is: every so often, a set of my records are displayed...

This reply doesn't help, unless one is willing to subscribe and pay the fees to experts exchange. FYI.

Solution, methinks! Hi Shan, and any others trying to do this, I've found a solution, maybe not the best, but it is working for me.... When I tried to do this, I would get "#VALUE" in my spreadsheet, and this must be based purely on the length of my data. I tried writing the value of the...

Have you had any success with this? I am trying to do something similar (almost exactly the same, actually), but in my spreadsheet I get "#VALUE" rather than any text. I'd be delighted to hear about a solution ....

How are you putting the URLs in? With a form? If so, you can concatenate the "http:\\" with your form value, something like this: Me.txtURL = "http:\\" & Me.txtURL where Me.txtURL refers to the textbox on the form where you are typing in the URL. Makes sense?

Take it out of the detail section and put it in the Report Footer section, not the Page Footer or Section Footer, but the Report Footer. That will work.

Not sure if there is a better way, but this might get you started: you can use format on the date field to determine the day and the date. Where dtDate is a date Field, Format([dtDate], "dddd") returns the actual day, ex. "Friday" Format([dtDate], "d") returns the date, ex. "24" you'd still...

Joe, try If IsNull(CustomerID) Then

I would have to say I disagree with that post -- I am not doing any formatting, distinct selecting etc etc. I am merely running an update query that says "take the value from textbox on form and write it into memo field in table" and in the update query it truncates at 255 characters. Now...

Leopardfist: I worked around this problem by writing a SQL query to load the data. I placed a "save" button on the form, and in the Events added this code: Dim strSQL As String strSQL = "UPDATE tblService SET tblService.Comments = """ _ &...

Thanks for helping out, this had me baffled.... Deep in my code..., written a long time ago in a galaxy far far away, I had written a little piece to enable/disable a command button.... Thanks for sticking with me. I thought I had the right approach, only one oncurrent event on the main form...

Well, as best as I can figure, the act of moving to the next record fires the tab control onchange event and moves me back to the page indexed as 0. As near as I can tell, there is nothing in my code in the form oncurrent event that does this .... I've trapped the tabcontrol.value in a global...

Hi folks, I've searched through the forums and found a little on tab controls, but haven't been able to figure out what I am trying to do. I have a form with mutliple tabs, each of which contains a subform related to the form on the first tab. When I am scrolling through the records, I might...

I'd suggest ASP, if the users want to be able to query the database and return specific (and up to date) sets of data. If they just want to be able to view data that is periodically updated, check out the Data pages within access.

try DoCmd.RunMacro "macroname". I think that ought to do it.

can you try it on Form_Current rather than Form_Open?

If the appropriate field is also on another tab, refer to that field on your active tab. For example, on the first tab of my form (named frmMemberInfo) I have the fields Surname, Given1 and Rank; on a secondary tab, create a text box, (change the background so it looks like a label) and...

Still a problem? I was just reviewing some of my posts, and see that there is no resolution posted here -- are you still having problems? There are a number of ways to "parameterise" your query so you see what you want -- let me know if you still want a hand.