Search results

Does anyone no where I can find a module the converts Numbers into Text. 1 = One 18 = Eighteen and so on.... Thanks

How can I take one time field and subtrack it from another and come up with the time difference? Ex: 03:00 pm - 02:00 pm ="1 hour" or "01:00" Both are medium time fields. Is this possible? Thanks, Jeff

Does anyone know how to convert Numbers to Text automatically? ie. 1583 = One Thousand Five Hundred Eighty Three Thanks

How can I generate a random number. I need to be able to input two numbers, the low and high ends then generate a random number between those two. I was trying something called "RANDBETWEEN(bottom,top)" that I found in help, but couldn't seem to get it working. Thanks

I used the code placed below but now I'm getting an error message saying " Run-Time Error '13': Type Mismatch " Any Ideas what the problem is? Thanks

Hi, How can I access a query in a module. To access a form I use: lastname = Forms(x)![lastname] Is it possible to do the same thing for a query? I tried: lastname = Query(x)![lastname] But it didn't work. Any Ideas? Thanks

I'm trying to set the value of the "Title" field on "SubForm1" to the value of the "Title" field in "Table1" where the "Code" field in "Table1" equals the "Code" field of "SubForm1" Can someone please tell me what I'm doing wrong? TITLE = DLookup("[TITLE]", "Table1", "[CODE] =...

How can I check to see if a form is open using code?

I'm want to be able to open up a form in a different database from within the main database. Example: I'm in Database "A", Form "1". I want to be able to click a button and have it open up Database "B", Form "2". I can get it to open up the Database, but I can't have it open the form. I...