Recent content by Laftrip

My workstation is SP3, and so was at least one of the others I tried. But if somebody else logs on my "box", it doesn't work, and if I log on to their workstation (where it doesn't work for them), it works with my Windows log on. I will double check, and consider applying patches, but I don't...

=Date() only works if I am logged on to Windows, why nobody else? I have created a database and everything was going very well. Today I finished the database, and I was giving a presentation to some employees at work. When my boss opened my database on his laptop to test it, the very first...

Well, I'm in Canada and we are using the United States format because that is where the company headquarters is located. I've found a way around my problem, I've removed the format property (the bug no longer happens) and kept the input mask and will do the insert using the string in vba.

Ok, I've tried using the database on other computers and noticed that on the computers with WindowsNT this problem doesn't happen. I have Windows 2000 Professionnal on my machine. Does anybody know of any issues, or extra settings that I should look at?

I have a problem which I have tried to resolve in many ways with no success. To troubleshoot my problem with as little possibility of error as possible, I have created a form with nothing but a textbox. The textbox is unbound. I have set the format (Me.txtDate.format = "mm/dd/yyyy") and in my...

I would love to know the answer to this... I have the same problem which I posted this morning...

I have a similar problem, but with a twist. I have 11 subreports on a report that are basically identical except for their names and the recordsource. My report is perfect except for the fact that I have 11 almost identical subreports. I also have another report with another 11 subreports, so...

Is there a way to do this with strings instead of numbers? For example, instead of adding numbers to have a total, I would rather concatenate strings to have an accumulated string instead? I've looked and couldn't find a built-in function like Sum() for Concatenating strings. This should be a...

Created new form... same problem Noticed something new however, I was so focused on the listbox I didn't notice before that when I can't select a new item in the listbox, I also cannot change the options in one of the option groups. The option group used to change the listbox still works, it's...

Because if I put it after, the item stays selected. I've tried your code too, but same result. I only mentionned earlier what is relevent code, but I actually have 2 option groups and 2 list boxes on my form. One list box depends on the 2 options groups, and the second listbox depends on the...

What I have is an Option Group, and when the user clicks an option, it triggers a after update event. The after update event creates a sql statement and puts it as the row source of my listbox. My problem was this: If I select an item in the listbox, it selects it. Then if I chose another...

I've tried this, and it partly works, but now when I try to select a new Item in that list, it won't select.

Rich, whoever you are, I don't know what you do for a living, but you've resolved my two biggest problems and made it look so easy. My project is practically completed now. Thanks a million.

I'll explain again... I'm so close to fixing this I can taste it! For the purpose of testing the hasData method, I have just created a macro that emits a beep. If I open a subreport that has no data directly I hear the beep. If I open the subreport via the main report, no beep! Now, the...

I tried changing the background color of the fields of the subreport that the NONE shows throught to white, not transparent and I still see NONE, does that mean that somehow it appears on top of the subreport instead of behind? In design view, it's definitely behind the subreport...