Search results

Isn't there some way to move to the next record? When the field is populated on the form it is populating a table.

Not yet...but will be if I ever get this to work.

Using Access 2007 DB windows 7 Main form on open of db collects the username from the environ. text Field(networkid) is populated on form from the function 1. On Open of DB it opens with a frmuserid which contains a text box holding the network ID which is derived from function...

Using Access 2007 Win 07 I've managed to grab the network login and place it on the data entry form which populates a table with said login... I would like to know where and how I would use that same login ID elsewhere in db. I only want that loginID to be able to use forms and reports...

I need to remove the mdw feature in order to convert. I don't want or need the mdw feature in the 07 version. My mind is spinning with all the security stuff I'm reading...

Have 2 2000 db's that I converted to 2003 and need to convert to 2007. Getting a security issues when trying on the 07 end due to the mdw security ??? Any options to get these converted to 07??? :confused:

Searching the forums, getting more confused..LOL! :confused: This should be simple code, brain won't allow me to think today. Using Access 2007 Have a DOB (date of birth) field in table. On field entry, I need to make sure the entry is not in the future. Properties of field in Before...

Thanks for the reply. Very interesting. I found the code you link to on another thread and someone suggested the environ as an alternative, but, not where to use or how.

Using Win 7 and Access 2007 db will be split and on a server If it's possible: Would like to use the Environ username somewhere in the db so the user only sees their records. Where would I place this? Or is their different code I should be using for this purpose??? :confused:

JDraw...I agree, the names are terrible. I'm working on an existing db of anothers' creation and too far in to change the names. I edited this post....I forgot to put the Round function in... this formula works... Excellent. Thanks so much.

format the start and end times to number, allowing for blank or null some answers will be 2.33366666

Using Access 2007 Win 7 Total_Time: Format(nz(DateDiff("n",[Start],[End])/60)) This is my expression in a query. I need to only show 2 decimal places in the results field. HELP!

Awesome...got it working... Thanks...

SELECT qryHoursReq.VolunteerId, qryHoursReq.Name, qryHoursReq.Program, Sum(qryHoursReq.Total_Time) AS SumOfTotal_Time, qryHoursReq.S_date FROM qryHoursReq GROUP BY qryHoursReq.VolunteerId, qryHoursReq.Name, qryHoursReq.Program, qryHoursReq.S_date HAVING (((qryHoursReq.S_date) Between [startdate]...

Using Access 2007 Windows 7 Multiple users on a server based db, connecting with a desktop shortcut On close... the .laccdb remains open Set attributes to shared Will not let me remove the .laccdb, saying being used by another I'm the only one in it Any suggestions?

I'm working on similar item. How did you get your combobox to pass on to the query? I've tried filtering the result field in the macro on the command button and the report. Won't pick up the combobox entry I selected to run the report?

Using Access 2007 Windows 7 Have 6 different reports open from a form. Each report is using a site parameter selected from a previous login form that will select a site with the correct password Originally reports and site selection were all on one form and reports generated correctly...

Well, I got it solved. A BIG DUH moment, LOL! created many queries to get to final result. Sub report not needed in the end... But, I learned along the way Thanks for all the help.

Thank you I will give this a try...

I did try the syntax but still getting the error message I think I need to create something that shows if null values