Search results

Why are they all declared as Variants? Try declaring them as a numeric type. Try what Banana suggested, set a breakpoint at the beginning of the function & step through to find what line is the problem.

Take the code that gets run by clicking enter, put it in a separate procedure. Leave a call to this procedure in place of the original code location. Put another call to this procedure in the "select" button onclick event.

I remember Spiderman's ending had to be completely remade, because the big fight with the bad guy was originally set on/around the towers. I also remember some ignorant people saying it was disrespectful for the second Lord Of The Rings film to be called The Two Towers :rolleyes: (it's a...

Open the subform in its own window, then create a subform on that form.

So, that code is in form load? and it works the first time? Try putting it in listbox onclick (and maybe keypress as well, to handle cursor up/down)

I spent 24 hours in Japan, in September '94. I think I spent about a minute of that outside :p Step out of airport, gasp stagger gasp, get in bus, get out of bus, gasp stagger gasp, go into hotel. Repeat in reverse. I did step outside the hotel once in between - saw it raining & thought that...

OK, thinking "out loud" here... it's not complete/valid code... dim AutoUpdate as boolean ... function NewRecord() 'check if current record is new ... end function procedure CompanyName_LostFocus() if NewRecord and AutoUpdate then CreateShortName() AutoUpdate = false end if...

Yes. Oh you want to know what they are? :p Will try it again & see... [EDIT:] OK, it gave me an error installing one of the files. So I tried re-downloading it. Noticed on the download page it says "Don't use a Download Manager", I thought yeah whatever & did anyway... got an error...

You can also use Tools - Analyze - Documenter This will produce a report containing every detail you could want about Access database objects. Be warned, it can take a while, and can produce a very LONG report if you ask for all the details...

I have done something similar just recently. Make a new form, linked to the subform's data. I'm assuming this has a FK relationship with the main form's data. Add a button to the main form to open this new form. In the new form's Form Open event, run the search. This will find you the record so...

An easier way is using the split function. firstname = split(fullname, " ")(0) lastname = split(fullname, " ")(1) However, this will cause problems if there are more spaces in the name eg John de Ath would set firstname to "John" and lastname to "de"

I've only worked with replicas a little but they were a right royal pain...

Yes that's what I meant Different header? hmm OK well my idea won't work then... I don't think I understand the problem well enough. Anyone else care to jump in with suggestions?

No, you just need to let VB know which Access file you're... umm... accessing :p

Another good one is MPC - MediaPlayer Classic I can't get this to install on my PC, don't know why :confused:

Some old ones for you... What do you call a cow with 3 legs? Lean beef What do you call a cow with no legs? Ground beef What do you call a bull that acts like a cow? Mince beef What's brown and sticky? A stick What's red and invisible? No tomatoes What do you call a deer with no...

It doesn't look like it would work for numbers above 9... it looks like it converts each digit to Roman, so 11 would be II, 99 would be IXIX (10, 100, and 10000000 would all be I?) :confused: If you only need numbers up to 9 then that's great, otherwise I'd rethink it. OK, just found this...

Do the same for the ranks too! (in a separate table)

Have the Description as the listbox's Value field, and the report's filter criteria

You may have problems with the department control having the same name as its data source. I'd recommend changing it to cboDepartment (cbo = Combo Box) or something like that. DoCmd.OpenReport "All users", acViewPreview, , "[AUP].[First Name] = '" & Me.[Text34] & "' and [AUP].[Last Name] = '"...