Search results

  1. D

    Copying Photos

    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...
  2. D

    Copying Photos

    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!
  3. D

    Copying Photos

    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...
  4. D

    Exporting Access Memo column to Excel

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

    Remove space and NewLine character on Export to Excel

    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...
  6. D

    Remove space and NewLine character on Export to Excel

    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 ....
  7. D

    Hyperlinks that don't

    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?
  8. D

    how to put the average value calculated at the bottom of specific column on Report?

    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.
  9. D

    First Business Day of Month Macro Condition

    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...
  10. D

    Stupid Message Box Question

    Joe, try If IsNull(CustomerID) Then
  11. D

    Text Box on Form Limits Entry to Memo Field?

    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...
  12. D

    Text Box on Form Limits Entry to Memo Field?

    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 = """ _ &...
  13. D

    Tab Control to mark page

    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...
  14. D

    Tab Control to mark page

    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...
  15. D

    Tab Control to mark page

    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...
  16. D

    Web development

    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.
  17. D

    Calling a Macro

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

    Form code not working

    can you try it on Form_Current rather than Form_Open?
  19. D

    Information label on form

    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...
  20. D

    Performing query on unbound data

    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.
Back
Top Bottom