Recent content by CliffHanger9

Thanks for the prompt reply Ok so pretend I dont want to change them. I just want to store them in a table instead of in the VBA code. I see your point, constant is the wrong word...if you have a better suggestion to solve this problem as described above I am interested. Thanks again!! :)

I currently have a module that has global variables set at the top. I would like to however store these values in a table so that I can build a form for someone who does not know VB and they can go to the form and change the settings, or values of the global variables. I would like to set the...

Thanks sfreeman - unfortunately I have at least 120 tables in this thing and unless there is a way to automate linking them this will be very tedious I have a very cool script that compares two tables to a decent level of detail but again this is at the database level vs the table level How...

Hello all- I need to compare two different datasets of identical databases. BY this i mean that I have two databases with identical structure (tables, fieldnames etc) however in one of the databases, some of the data has changed. I need to see the differences in what has changed similar to the...

hahaha...jerk :p jk - Thanks alot! thats awesome! I knew it was something simple there isnt a way to pass in default properties for that is there? like as far as file type and the directory path to look in?? if not, no worries but would be cool to add... - THANKS AGAN!! :cool:

yessir! http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/acmthCreateDatabaseX.asp

Hi all - this is probably easy but I cannot find functioning code for this for the life of me.. How can I open the Import dialog box from VBA? I have a button on a form that reads "Import..." and upon clicking it i would like it to trigger the import box. This will become a function called in...

THe problem with this is that i cannot run calculations for my reports on text values ;) Thanks guys! :D

on the fly? elaborate please thanks!

Anyone have any ideas how to create a function that would change the datatype of a table field?? I have data that is imported to access so it is put in as text and I am hoping to run a macro to convert the text field to a DATE field so that the report can properly calculate things. Thanks in...

No you dont. Set up a linked table from your external database to Access (you can use ODBC). Then set your query as an Append Query and dump the results into the linked external table. no exporting. no excel. all you have to do is open the query. Hope this helps.. ;)

like this? =Sum(IIf((Now()-[KLIXLAST_LOGIN])<46,1,0)) ...? #Error :( KLIXLAST_LOGIN is a field bound to a table - date datatype. thanks though

Hi Pat - thanks for responding and confirming that i have not lost my sanity this is the formula i am using which produces the #Error message: =Sum(IIf([txtDaysSinceLastLogin]<46,1,0)) any other thoughts?

HI All- The title sorta sums this one up.. What is the best way in Access 2000 (expression builder) to replicate the COUNTIF functionality of Excel In case you are not familiar with this, it essentially scans a field and counts the number of a specified instance. So my text box calculates...

nevermind then.