Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. OzFoxy

    Run-time error '3075': Syntax error (missing operator) in query expression 'Birthday = and Birthmonth ='.

    ...When I run your code I get the exact same error. When I add: Dim dSelectDate As Date dSelectDate = #11/12/2024# to your code, sql becomes SELECT * FROM [qryBirthdayList] WHERE Birthday = 12 AND Birthmonth = 11; and all is AOK. So it seems your dselectdate is either not a date, or it's empty.
  2. OzFoxy

    COLORIZE frame border , possible?

    Is this what you mean?
  3. OzFoxy

    Formula with & and a single quote

    Hi Andrzejek, Trying to write a formula that will give me in the cell: strStepValue = "'" & !PT_COLOR.Value & "'" Deniall has hit the nail on the head. I'm confused about 'PT_COLOR' and 'CA_SOL_DISP' so I have assumed that the content of C5 is as shown on the attachment. The formula in B2 is...
  4. OzFoxy

    Concatenation problem

    Hi Moss100, try this: ....... = '" & Me!cbo_Landlord_Select & "'"
  5. OzFoxy

    MsgBox on alternate days

    I am not a VB Scripter, but I hope the logic in this VBA code is helpful. Dim lngLastDay as long Dim blnShowOnEvenDays as boolean ' Determine the last day of the previous month lngLastDay = DateSerial(Year(Now), Month(Now), 1) - 1 ' If the last day of the previous month was 29 or 31 (odd)...
  6. OzFoxy

    Outlook 365 images/graphics not displaying

    Thanks in advance - any help will be appreciated. Emails I receive from Ali-Express do not display graphics or images and links aren't active (no response to click). See attachment. Emails I receive from any other senders display correctly. Outlook settings are to download images automatically...
  7. OzFoxy

    Outlook Template replace text

    Hi Andy, what do you mean by 'messes up the other formatting'? Is it just messing up the alignment, changing fonts / font weights, converting everything to plain text? The first step in problem solving is to understand the problem. Can you be more specific?
  8. OzFoxy

    Grid From

    I'm not sure what you want to achieve, but hope this helps. I copied your 'butter.jpg' to my c:\ and renamed it to 'butter.bmp' In tblCmds i changed the first 7 PhotoURL's to C:\butter.bmp In the form load code I added Dim pic as variant I modified the code as in the attached screensnip and got...
  9. OzFoxy

    How to get AttachmentCount from a field in a table

    Thanks Andrzejek, but that code produces the error 'Run time error 438: Object doesn't support this property or method'. It is apparent that the property 'AttachmentCount' is only supported on form controls. I worked around the problem by creating a form just for the 'Attachment' type field, and...
  10. OzFoxy

    How to get AttachmentCount from a field in a table

    Hi Team, my Asset Register DB has a table which includes the following fields: A yes/no field [Image] to indicate if a Photo is required. An attachment field to contain the photo [Photo] In the form code, me!Photo.attachmentcount returns 0 or 1 for the current record, no attachments or one...
  11. OzFoxy

    CONVERT MACROS TO VBA

    I prefer VBA code to macros. Access 2010 automatically creates Macros when I use the Control Wizards, which I then have to convert to VBA. Is there a setting in Access 2010 to tell Access to create VBA procedures instead of macros. Thanks Foxy in Oz
  12. OzFoxy

    Access 2003 crashes when I add an option group

    My .mdb includes a form with 7 option groups on it (3,4, or 5 options), and I need another option group. When I add it to the form, and either save the form or switch to Form View, Access crashes with the 'Microsoft Office Access has encountered a problem and needs to close ....' dialogue box...
  13. OzFoxy

    error setting a tempvar

    [Cardholder Name] Like '*" & Tempvar_CCN & "*'" I believe with this code you will run into problems with names containing an apostophe e.g. O'Sullivan, where the result will be: [Cardholder Name] Like '*O'Sullivan*' This may be preferred: "[Cardholder Name] Like ""*" & Tempvar_CCN & "*""" To...
  14. OzFoxy

    Need to make a report list items horizontally.

    I'm sure someone will come up with a more efficient way but .... Given that there will probably be more songs per artist than will fit across the page, how about creating a (temporary) table with fields: Artist Song1 Song2 Song3 Create a query to select the data you want, and write it to the...
  15. OzFoxy

    Exporting reports to PDF

    Hi Techkenny1, I am assuming that your invoices are a report from an Access app. I had a similar requirement and solved it programmatically using ConvertReportToPDF from this website. Once it is installed into your app, it's just one line of code to output the report as a PDF file...
  16. OzFoxy

    MSFlexGrid - A solution

    Hi FossilFool, I have VB6, but not installed on my machines, so yes I downloaded and unpacked. I did the procedures documented in my earlier post on one machine. On the other machines I just copied the OCX and registered it. I haven't deleted any .exd files, none of the ones I found on my...
  17. OzFoxy

    MSFlexGrid - A solution

    The problem with uninstalling the update is that it leaves the machine vulnerable. In all conscience I could not do that to my clients, quite apart from the possible legal ramifications. Providing a CD to clients with a batch file to copy the updated OCX and register it, is a small price to pay...
  18. OzFoxy

    Error "Object Invalid or no longer set"

    I'm using Access 2003. Pressing Escape after changes are made to text boxes on a bound form, and a text box has the focus, triggers the FORM undo event. Pressing escape whilst a combo box has the focus does not trigger the undo event. Hope this helps.
  19. OzFoxy

    MSFlexGrid - A solution

    This is how I solved my MSFLEXGRID / KB906715 problem. Created a folder C:\VB (for convenience - optional) Downloaded the VB6 SP6 Cumulative Update (KB957924) into c:\VB from: http://www.microsoft.com/downloads/details.aspx?FamilyID=cb824e35-0403-45c4-9e41-459f0eb89e36&DisplayLang=en Renamed...
  20. OzFoxy

    Error "Object Invalid or no longer set"

    Anoher seniors moment. The code should break at the debug.print line!

Part and Inventory Search

Back
Top