Search results for query: *

It's looking like there's not goo way to do what I'd like. Darn. But I was thinking, what if I were to predict the most common types of files to be attached and then execute a series of print statements to print these files. Example: dim rst as dao.recordset Set rst =...

Does anyone know code that will work to print out a series of non-access files, regardless of what type they are? I have a table structure where people can "attach" various documents to their record. Really the table just stores the directory of the file they've attached. I would like to run...

Thanks - that worked. Now I need to go and change my VB code which constantly updated that SQL as a series of variables to instead change a querydef. Strange problem, but your solution worked great. Thanks!!!

Very strange problem... I noticed that one of my listboxes is missing some records, and so I checked its underlying query (which is assigned through the listbox.rowsource VB property) to find the problem. The strange thing is that the missing records ARE present in the underlying query results...

Also I wanted to add that even if had seen this cool concatentate function, I probably wouldn't have thought to put it in a crosstab to accomplish what I needed to do. The crosstab and conc. function work great together. I learned a lot from this exercise. The query field: OptionNames...

Thank you both for your suggestions! Duane - you are brilliant and you saved my butt. I ended up using your concatenate function (the one that separates "records" with a line break within the field)with the crosstab and it works great. Your function ended up being: Function...

I am having some report formatting trouble. My fields are as such: HouseID Option Name Option Type 34 Sunroom Structural 34 Loft Structural 34 Side Entry Garage 34 Service Door Garage 34 Dining Bay Bay...

Thanks for the comments. I ended up just creating a new temp table and throwing all the relevant chart data in there, as well as one date for the first of each month. Then I run a totals on that temp table as a basis for my chart. Works really well. Here's the code if it can help anyone else...

I have a line graph that charts Gross Profit $ earned each month. In some months, there was no GP reported, so technically the value would be "$0". But since nothing was entered for the $0 months, the value is just skipped over in the chart. My data is like the following example: DATE...

I am trying to dynamically refer to a variable name. I have multiple search variables: condCity condState condZIP condCustNum, etc.... Each one is an sql WHERE statement used in a rowsource assignment for a listbox. Example: rowsource = condCity & CondState & condZIP ... All variables...

I'm trying to append the data from multiple Excel spreadsheets into an access table. The Excel files are version 5, and new ones are constantly being downloaded from a remote site - so there is nothing I can do to change each one's format on the creation end. The code I'm using is as follows...

I finally got it -- I have to set the dest listbox to null: me!dest = null in order to requery it and set focus to it. Don't really know why, but it works!

TheAceMan1 & lastout Thanks for the info on the bang. I revised my code to have the ! instead of . where pointing to a control. I also simplified my example code even more to eliminate anything extraneous to describing this problem. (like the variables you were asking about why I didn't pass...

TheAceMan1, No, they are not on a subform. I even tried making a dummy form from scratch, putting generic listboxes on them with very simple data, and got the same problem after running my highlight procedure.

Hi Aceman1 I have a requery right at the end of the highlight procedure. I can see the new records just fine, I just cannot click on them on the first try.

Hi PH, I've tried that in many places, and it generates various errors. Access won't let me change focus with that command after running the loop.

Hi everyone, I'd be grateful for any assistance... I have 9 listboxes ("list1", "list2", "list3", etc..) that are lined up on a form. When a user clicks on one of them, I need all the other listboxes to have the same index value be selected as well. This works well with a for...next loop, and...

Thanks gol4! Just had to add a rs.edit and rs.update and it worked great. Much appreciated!

I have a table with about 1500 records. Table is made up of repeating chunks of 112 records. Each group of 112 records is a pattern that establishes a class scheduling system. It is made of 14 weeks * 8 class types = 112 records. tblClassSchedule ID WeekNum ClassID LocationID...

Works like a dream... thanks!