Recent content by TravelingCat

Hi Arain, thanks for replying but this thread is 3 years old I no longer work with access Maybe it will help someone else;)

Super! It finally works as i wanted for a long time now. Chris, thank you so much for returning to this subject and helping me out:)

Hi Chris, thank you for your detailed response. But Lebans has its own variables for defining pathes, snapshots and what not - strPathandFileName, strPath.. i wonder how do they blend with your variable OutputFile? Do i use both them and yours? And his DoCmd.OutputTo looks like this...

Hi Chris, I read your post and i have a question regarding what you said here "export the reports to specific folders on our network (with the path coming from a field in one of my tables) and had the labens code setup to do that". I also use Lebans code, and i also need the report to be saved...

Trevor and Dave, thank you! I feel really dumb for not thinking about this myself..:o

Yes i understand that will be the most logical, but i already use it in some places as it is, and the program is already in production, so i'd rather solve this without creating another table, if it's possible. Can you explain in a little bit more details how to do this?

Hello, I need to make a query, which will use one table. This table has a field called "participatedHow", which stands for how did worker participate in a certain event (1 = present, 2 = via telephone, 3 = ..., 4 = ...). The problem is that this field is represented by numbers 1 to 4, but there...

darbid, :) No can do.. i still need my paycheck:) stopher, if that's the case, then it's really unfortunate that i'm using access 2003..

Hello, i'm lost. The boss wants to be able to write text and design it as he wishes (bold/colors/different fonts/different sizes/etc). I handled that as follows, every time he wants to write text i create a word document, it's saved and can be viewed at anytime. The problem is, i later have to...

I didn't write it because it has to do with my program specifically, so it wont help anyone i think. Anyway, the listbox is inside frmAssignments, which is the subform of frmEvents. In order for it to display the right assignments, it should get current event number. The problem was with the...

Thanks for your help, but i solved this one

Thanks, but it always have been very difficult for me with these events, i never know when they fire.. I also have reports listbox on the same form, so i've put a breakpoint on the form's after and before update, it never fired. Would appreciate more ideas..

Hi, I have a mainform, and a subform in it. The main form contains current event details. The subform has ListBox control which contains assignments of that event. To add a new assignment, you click on button and another form opens. The thing is, if the listbox already contains some assignments...

This is how my row source looks now that i've inserted your code: SELECT assignHasSubassigns, Iif([AssignType]=1, "Assignment", Iif([AssignType]=2, "Decision", "Text")), assignDueDateNew, assignDueDate, statusName, assignInCharge, assignDescription, assignDateOpen, assignNum, assignRecordId FROM...

vbaInet, about your second suggestion, can you please write a short pseudocode or something? I don't get where would i put an Iif statement inside the SELECT .... , how is it done