Search results

Dave - After playing with this for a while, I'm afraid I have to agree. Don't find a reliable way to designate table vs. query as the record source. It doesn't help that MSys is undocumented in the help file. Would sure be interested if someone were able to come up with a method. Best Wishes...

Hi - What is your FY start-date, and the logic for developing your table? If it's consistent, it'd probably be possible to develop a dynamic lookup. Bob

Dave - Glad you found it helpful. I wrote it eons ago and had to grope around to find it. Incidentally, I've got a number of similar variations already written. If you've got other needs, please post them and perhaps I can help out. Best wishes - Bob

Hi - To carry this a step further, the following sub, copied/pasted to a standard module, will create/recreate tblQueries4 and populate it with the name of each query in the database, along with the name of the source table(s)/ query(s) for each respective query. Public Sub GetQueries4()...

Hi - Take a look at this post and see if it provides any assistance. HTH - Bob

Hi - 'Real' numbers don't have leading zeroes. What is it you're attempting to do? Bob

Hi - This will create/recreate tblFields and populate it with table/field info for all tables in your data base. After copying/pasting it to a standard module, name immaterial so long as it's not the name of one of the subs, invoke it by entering Call GetField2Description from the debug...

Take a look here HTH - Bob ----- That link apparently doesn't want to work, so here's the full text I was pointing to: Hi - This function will allow you return age in years based on specified date, or the current date (see the 3rd example). In your query try creating a calculated field...

Hi - Assuming it's actually a number, here are steps to convert it to a date. Then, you'll find numerous entries in this forum for computing age (need to know if you just need age in years, or years/months, etc.. x = 37704252536 ? x 37704252536 y = mid(x,2,6) ? y 770425 z =...

Oh boy, here we go! 14 posts and we're still going 'duh-huh'. Maybe, Paul, you may need to provide a Google map to the help file. Best wishes -- Bob

Hi - The attached form, based on the Cool Search Tool concept (do a search on this forum) allows the user to search specified fields by entering the criteria into one text box. You can enter any portion of any field and, with each keystroke, the search function will drill down to those records...

Hi - Take a look at this post. My post looks kindof long and complicated, but all you'll need to do is copy/paste it to a standard module, then call it as shown in the description. No modifications should be necessary It allows you to forecast the next anniversary of an event (e.g. Hire...

Hi - To convert your example to US format (mm/dd/yyyy): x = "04.01.2003" ? dateserial(right(x,4), mid(x,4,2), left(x,2)) 1/4/2003 Bob

Think you'd find it helpful if you'd stick with one thread, rather than opening a new one for each problem with the same issue. Bob

Hi - Dave, help me out here: so int(62.99999999) is 62 How do you get 90 * 07 reutrns anythinyg other than 63? Bob

Hi - I gotta ask: How does a thing like that work? 90*0.7 = 63 there's no rounding involved. Bob

Hi - Any other examples that don't include the Int() function? Think the potential structure of that further complicates the issue. Bob

Hmmm - That's interesting. When I attempt to test your posted solution, I get: Here's what the Help File says about the IIf() function: Bob

Hi - After taking a look at the Help File(s), please post a working example where the False portion of an Iif() statement can be successfullly omitted. Bob

Hi - Now() is a date/time data type which includes both date and time, e.g. ? now() + 30 7/21/2009 8:18:32 AM To include just date, no time, use date() ? date() + 30 7/21/2009 [Betalningstidpunkt] should be stored as a date/time data type. The Iif() statement must include both a True and...