Search results

No, your fe/be will automatically lock records in use so there is no confliction, whoever edits 1st has priority.

Trying to pull up records that have any scheduled day/time in another range of date/times. Ok: In my Table i have Scheduled Start and Scheduled Finish, and on my form i have Period Beginning and Period Ending. I need to pull up any records that are scheduled to be active between Preriod...

could have sworn i checked for that... thanks...

Is there a way in VBA to get the current record number, i cannot seem to find a property in the form, nor an answer in the search on the fourm.

I think this in the wrong forum buddy..

sql = "SELECT * FROM tblMyTable WHERE {insert your where clause here}" rst = CurrentDB.openRecordset(sql) while not rst.EOF sql = "INSERT INTO tblMyTable (field1, field2, field3) VALUES ('" & rst("field1") & "','" & rst("field2") & "','" & rst("field3") & "')" CurrentDB.Execute sql...

Two methods: 1) Set up datasource on a server, and get the server to run a macro ever 5 mins or something that updates them. 2) Set up fe to do the same thing on a form timer.

Access dosent like deleting stuff when you delete it. Lets say X represents DATA and Y represents structure info (queries, forms, etc..) and let's say O is blank data Here's a sample file...

If the control source itself is the function, it cannot push the data back through the controlling function to reproduce an encrypted value to update. So, you need to go an alternate method. Have the form set the value on load with code and then have the text box set the encrypted text to...

Add a WHERE clause to your rowsource that makes the stuff you nee LIKE the txt/combo/whatever box on your form. Example: "... WHERE [tblRec].[Subject] LIKE [Forms]![frmMyForm].[txtMySubjectFilter]"

From time to time the connectivity of the site is poor but that's what you get for $0.00/mo. Im sure if everyone were paying the owners $9.99/mo. They'd have dual OC148 lines for the server as well as hired and trained professional consultants who sit there all day in different timezones...

the big walnut

boogers hanging from

If im remembering correctly (good chance im not) the developer edition can turn them into exes.

You both seem pretty childish to me, i mean come on.. this is an access help board, not a gathering forum for 11yr old kids desperatly awaiting the next DragonBall Z game or pokemon episode. Let's keep the flaming in those boards, not here. Although I don't have an answer for you arvindn i...

Simple solution: $75usd...go get another 512 stick

snot from the

World's best and easyest reference for exactly what you're looking for. www.w3schools.com Click ASP and ADO on the left, that'll teach you everything you'll ever need to know.

Not sure exactly what you mean but try this: In your table make two yes/no fields called Report1 and Report2 then make a checkbox on your form and make it's controlsource corresponding to whichever one of those two fields. Then when you run your report, filter only those with "yes" in the...

Wow.. one big super godlike DLL =D yummy. Let me know if you need any more mathematics help (or any help for that matter) I have VB.Net @ home, i also may be able to help port it to .Net