Search results

Try: archivetableexists = Nz(DLookup("[Name]", "MSysObjects", "MSysObjects.[Name] = '" & strArchiveTableName & "'"))

try putting this in the Record Source propery: SELECT * FROM {myTableName} WHERE {myFieldName} Like [Please Enter The Record Number:] Now, you only need to replace {myTableName} with the name of the table that you wish to grab from, and {myFieldName} with the name of the field that the ID is...

Thanks, and sorry for the duplicate.

I have a split DB setup (you know, Front end and back end) that's used throughout the maintenance dept. here. My Backend DB is locked up with your simple Startup stuff (nothing too killer) buy just enough to keep the computer illiterate out of it so they wont mess it up. Im looking for a way...

Thx for the info guys.

What kind of security problems have versions of access encountered with the new SP2? For I noticed a lot of programs have been having issues recently. Just havent played with office yet, I presume that it's all good because it's all made my Micro$oft, but you never know... Just let me know...

49 choose 6 = __49!__ 6!(49-6)! If i remember correctly from discrete math. Which is: _______49*48*47*...*2*1________ (6*5*4*3*2*1)*(43*42*41*...*2*1) Which is a VERY Large Number.

Make a third report with no detail, and both 1st 2 reports in the report header as sub-reports. Then save that big report to file.

UPDATE facturen SET facturen.Factuurnr = DMax("[factuurnr]","fracturen") + 1 WHERE (((facturen.Factuurnr)=0)) WITH OWNERACCESS OPTION;

Never mind... I am stupid. (Got it.)

Im sure it's a bit duplicated, but i cannot find the specific answer to my problem. This database, even though i've bypassed with the SHIFT key, has NO sequrity file, but I cannot modify the design. Cannot import, link, or use anything that involves modifying/creating in it, cannot even convert...

Forgot to mention that if you use ADODB.Command you can call pre-defined queries and input parameters right into a query in the database. Mind you, you can SELECT * FROM {insert query name here} already, but it's where you can specify parameters and have much more detailed WHERE clauses ad...

http://www.w3schools.com/ Read SQL, ASP, ADO Here's an example: Database: testdb.mdb __Table: tblTest ____Fields/Data:_____ID___NAME ___________________1___Brian ___________________2___Kevin ___________________3___Gill Asp: <% Set Conn = Server.CreateObject("ADODB.Connection") conn.Open...

Woah Woah Woah!!! Hold up, javascript is client side yes, and so is vbscript, but both can be set up to parse via the asp parser, producing a HTML file (in other words, server-side scripting) In HTML sent to the client: <script language="javascript"> <!-- --> </script> That is a client block...

What if they overlap? Like, this: Daterange1:__||||||||||||||||____ Daterange2:________||||||||||||||

Make a form, make a text box, goto properties, goto data tab, click ... on Control source, select functions, open rollout, select Access-Functions Read Then open up the vba code for the form, press f2, browse.

Why put it in the form? Just declare it as public and call it from your button.

ASP is a dumbed off version of Visual basic, PHP looks like c++ but not ASP.

What are all the requirements for a query to remain updatable?

If you use ASP pages (glorified version of vba with web objects and no variable types) you can use as many as you need, you're just using ADODB insread of DAO so ADODB is way more picky about the lockfiles.