Search results

Hi Luuk - Whew, doesn't sound like an easy one to me. If you want to do this in a query, then the only thing I can think of is to do this in two stages. First, set up a query with ten columns to check for each of the preceeding months. Then if all ten are present, set a flag that indicates...

Hi Naomi - Welcome! An input mask only affects how the data is put into the field. It is a rule for deciding the valid format for data entry. The display format controls how the information looks. Try changing the display format property to the following: dd/mm/yyyyy hth, - g

Good work, Andy. I think I was just along for the ride on this one. You did all the work!! - g

Hi Pat - Here's a work around. 1. Set up a table that has all the Hours that you want to appear as row headings. This field needs to be compatible with the existing rows that you are getting out of the Crosstab query. 2. Make a new query that draws upon the the new table and your existing...

Hi - The transparent button with an unbound textbox behind sounds like the best approach to me. Continuous forms present additional challenges and you may find it necessary to use VBA to modify the textbox rather than straight conditional formatting. hth, -g

Sure, here is a bit more detail 1. Calendar Grid Make 6 rows x 7 columns of unbound text boxes. [Did I say 5 rows before - silly me. The reason that you need so many rows is that a month of 31 days can span over 6 rows if it starts on a Fri or Sat.] It really helps to name each text box...

Yeah, I think that people who don't work with Access even understand what *real* frustration can be.... 1. Converting Dates to Days If your date fields are actual dates (and not just text), then I still think that DatePart could be of help. E.g. WHERE (( DatePart("d", tblData.DateFrom) > 1)...

You can nest multiple conditions in one WHERE clause, e.g. WHERE ( ( (Condition1) AND (Condition2)) OR (Condition 3)) (Just keep track of those parentheses!). - g

Hi - Check out the DATEPART function E.g. DatePart ("d", <some date variable>) returns the day of the week. DatePart can also break out years, months, hours, etc. There is also a WeekDay function that returns the day of the week. hth, -g

Hi Brad - I have found the help to be very confusing as well, although once you can master it, it really can "help" find solutions. It seems like most of the tutorials on the web are geared towards VBA for Excel. This is not necessarily a bad place to start, since Excel is a little more...

Hi Lee - welcome! There are different types of queries: updatable and non-updatable. Using an aggregate function (SUM, MAX, AVG, etc.) can create a non-updatable query. It may also be a factor of your joins of the tables. Take a look at the following link and see if that is any help -...

Hi Pat - So you recommend building a query that returns only the desired RecordSet and then opening the form based on that query? - gromit

Hi Andy - Merging from Access to Word is not my strong point. I normally do my merging from Excel to Word. Are the fields truncated in the Excel (export) from Access or are the just not making the import into Word? Can you tell if the fields are truncated by length, or is it by character...

Good job in getting things sorted out. When you import into Excel are you using delimited text or fixed width? - g

Hi - I would do this in two stages - 1. Generate a query that first breaks the TYPE OF COVER into categories. You may be able to use a Crosstab query for this or you may need to use expressions with the IIF statement to generate counts for each one. 2. Generate a second query that utilizes...

hi danny - What is the data source for the list box? Are coming from a table or from a value list? Have you tried printing out the strIN variable to see if it has the leading 0's there? -g

Hi - welcome! Can you post a (very) simplified version of your tables and query? - g

Hi - Have you tried a query using the MAX of the autonumber? - g

Hi - With some VBA code you can go through the booked dates and set the background field for each one to grey. 1. Set up a general calendar grid (5 weeks x 7 days) on your form 2. Determine what the month in question is. 3. Populate the calendar grid with the correct numbers (place the...

Here is some example code that steps through each (existing) record in a table. The table has at least two fields: Name (text) and Number (number). ' Declare variables Dim db As DAO.Database Dim rs As DAO.Recordset Dim strSQL As String Dim intCounter As Integer intCounter...