Search results for query: *

Hi everyone, I'm having the devil of a time remembering the proper code to create a search textbox on my form that can be used to make "inexact" matches. Here's the setup: I have a form based on a table called Books with a couple of fields I want to search on: Title and AuthorLN. Want to be...

I am having no end of trouble trying to work with the DTPicker control. I keep reading in the posts (and on the MS site) that the way to change the default date on this ActiveX control is to set the value property to the desired date on the Form Load event. Which I do, Private Sub...

Hi All, I have developed an app in 07 and I have a user who is trying to run it in version 10. He is getting the usual msg: "Your Microsoft database or project contains a missing or broken refernce to the file 'MSCAL.OCX version 7.0' " How can I get this app to run for him? Thank you for...

Hi All, Am using ver 2007, I have a memo field with several lines, separated by returns, here is an example of this field data: 1 ) EXTENT OF VAPOR LEAKAGE OUT FRESH AIR DAMPER? 2 ) COLOR OF WATER IN SEAL? (LIGHT BROWN IS NORMAL) 3 ) SUPPLEMENTAL AIR FAN MECHANICALLY SOUND? 4 ) FD FAN...

Hi all, I am trying to write a little code to analyze the current time when a button on my form is clicked. I need to know if the current time is between 12:00 pm and 6:00 pm, or between 6:01 pm and 12:59 pm. I am using a variable called TimeOfDay to capture just the hourly info of Now(), and...

Hi All, I am using version 2007 and having a little trouble hiding duplicates in a grouped report. I have a series of issues being reported on and various responses to these are kept in a separate table. I used a single query combining the info in a basic report with no grouping, and hiding...

Hi all, I am having trouble refreshing a series of graphs in my Access 2007 application. Here’s the story: I have five graphs on a Main Menu form, they are in five subforms. The user opens a Complaint form to enter information that these 5 graphs track. I would like the graphs to update when...

Hello all, I think I’m going nuts. I am trying to use a function to provide the criteria for a query and am getting no results. Here is the SQL: SELECT tblComplaints.ComplaintInitiator, tblComplaints.ComplaintID, tblComplaints.ComplaintNum, tblComplaints.CustomerName...

Hi again all, This must be my week for Access problems! Using ver. 2007, I am trying to customize the ribbon as follows: Don't want any tabs except the Home and External Data tabs. I have the USysRibbons table all set up,and have a record for a RibbonName: SpreadsheetRibbon and the following...

Afternoon all, Despite a thorough search I can't find a discussion about formatting list boxes. I know it's very limited, but I'm using ver. 2007 and the properties sheet shows several properties for gridlines when I select a listbox. However, when I set these props, nothing happens . . ...

Hi All. Using ver. 2007, I would like to have a label change bg color when the mouse moves over it and then return to its usual color when the mouse moves away. I have used the MouseMove event to achieve the first part of my wish, but the color stays, and after searching the postings, have not...

I don’t even know if this can be done, but here goes: Using Access 2007, I have a table of playing cards, and am using an attachment field to show their images on a conventional bound form. And all is working well with this. Now, I am trying to lay out an unbound form upon which I want to...

Hi All, I’m having the devil of a time with this one: Am using ver. 2007 and have got the USysRibbons table and a public procedure to hide and show the ribbon at will. Most of the time this is working fine, except . . . I have a form with a tab control on it that has 3 pages. The first page...

Hi all, Using version 2007, I have an unbound form with cbos and a listbox to filter a report. I got this code off a Tek-Tips FAQ by Michael Red many years ago and have used it happily in many applications for my clients. Up to now, I haven’t had any problems. This is, however the first time...

Hi all, Using ver. 2007, I am having some trouble with a subform. This is probably simple to solve, but my noggin won’t wrap ‘round it. I have locked controls on a main form, and it works fine. I would also like to lock controls on a subform (which is on another tab page). I’ve tried putting...

Hi all, I need to order my records so I have continuous odd and even numbers --can't use the autonumber field due to skips in numbers (deleted recs, canceled recs, etc). I want to do this in a query so I can use this counter for conditional formatting on a form, and so it will continually...

Hi All, Warning: I am VERY new to SQL Server. I am trying to paste several records from an Access 2007 table into a new SQL table in SQL Server Management Express 2005. I used this method to transfer records several times this morning with 3 other tables (approx. 160 records) and it worked...

Am using version 2007 and need to evaluate the difference in 2 fields. I created a query that gives the interval in hours between 2 datetime fields. I then used this query in another one. Needing to isolate those that are less than 16 hours, I used <16 as my criteria. As below: SELECT...

Hi All, Using Access 2003, I have a query (acting as the record source for a report) that picks up dates from a form --this part is working fine. I also have a multi-select list box on the form, allowing users to select more than one ProgramID for their report. I am stumped on how to write...

I have a text field in an Access 2003 DB. Many entries are text, and many are just numbers. I need to isolate the records that have only numbers in that field and can't seem to come up with a criteria do it. I confess I've searched the forum and not found my answer, possibly because I'm not...