Search results

I know this is probably obvious but how do I pass through form variables to sql server I currently have: exec QStudent @_param_cmbYear="0708", @_param_SelID="S", @_param_SelForename="d", @_param_SelSurname="S" this executes correctly SelID being a student ID or partial ID also allowing for...

I am trying to upscale several databases from mdb to sql server. Unfortunately I am not sure of all the programs that use these database tables. Is there a way for the mdb to store what programs request data from it or alternatively the username. Im thinking not but worth a check.

I have been posting a lot recently and have greatly appreciated the help. I have just been looking at the size of a ms access project, this is a front end for another database so contains no data (runs as an mde for most). I have made a few modifications using access 2007 including at one point...

Anyone know any issues that would stop me down grading an access 2007 database. Someone up converted it without me knowing but I want it to be usable for people on older versions. I went to save as access 2003 and nothing happened. My initial thought was recompile the vba code and do a compact...

I posted a while back about an extremely slow query when using access 2007 but the same query in access 2003 runs fine. I have since tracked the issue down to a select distinct statement. If I change it to just select the query runs in about 45 seconds which it does in access 2003. I have tried...

Any ideas why a particular query would run very slow in access 2007 when it runs fine on 2003. This is running on a terminal services environment and the database connects to a ms sql 2000 server. I will try it outside terminal services when I can but I can't understand the problem. Im not...

At work we have a terminal services setup for most of the staff which is being configured now. We have hit a snag with access security settings basically we need macros to run for relinking odbc databases and various vba functions (some run overnight so we don't want to deal with the security...

My situation is a form is opened where a user enters query constraints. Then they press go, this runs a bit of vba code which opens a report (the report is linked to a query which references the form object and seems to work). The report shows at the top the query constraints referenced...

im trying to run this: DoCmd.openForm formName, , , [Attendance Sector]![School] = [Forms]![Explorer School]![School] Attendance Sector being my forms data source table with field school being compared to the one on the form but it errors with [Attendance Sector] external name not defined. I...

im trying to run this: DoCmd.openForm formName, , , [Attendance Sector]![School] = [Forms]![Explorer School]![School] Attendance Sector being my forms data source table with field school being compared to the one on the form but it errors with [Attendance Sector] external name not defined. I...

Hi at the moment I am using a bit of VBA code like below: Public Const currentYear As String = "0708" Static Function GetCurrentYear() GetCurrentYear = currentYear End Function I then call this from my ms access sql statement with GetCurrentYear() am I correct in thinking this will only need...

How do I pass the form object to VBA from an OnClick button action. I originaly had: (onclick event) =closeForm("the name of the from") then Public Function closeForm(formUsed As string) //do some data checking here DoCmd.Close acForm, formUsed End Function but I wish to change it to...

I am working on a student register system, I am trying to modify someone else's existing access application and came across this: TRANSFORM First(absence_code) AS FirstOfabsence_code SELECT acad_period, student_id, register_id, register_group, First(absence_code) AS [Total Of absence_code] FROM...

Im trying to concatenate a bunch of fields (50 arghh) which each are either blank or just contain one letter. This was someone elses setup for an attendance register which I think is an odd way of doing it. I would have used one field and then to get the mark for a week take a substring at the...