Search results for query: *

Hi, Is there any way of hiding a field based on an AD group of the user running the t-SQL/SP. I was think of a function that you could call that checked the AD group and then returned TRUE if they belonged in the required AD group. Then you could substitute a fields contents with something...

Hi, I have inherited a database which has numerous (70+) queries all with a date range criteria (i.e. Between #01/01/2011# and #31/12/2012#). Each month someone has to change the date range in every query and then run it to get stats out. Is there any quick vba code to loop through each...

I am new to SQL server so am looking for a bit of guidance (and hopefully in simple terms). I have to create a pseudonymisation function to turn a 10 digit number into a 10 digit alpha string. This is then has to have an unlock function to be able to turn it back. Basically it needs to be the...

I have had a look around the forum for this and there are lots of examples but I am struggling to understand them. I am hoping that if I use my own data then I will be able to understand it better. I have a table called 'tbl_Drugs_Prescribed'. This table contains 15 fields of which I only...

I am trying to do a simple query. I have a dataset which is 2 fields (AdmissionDate and DischargeDate). I want to be able to run a query where I supply a criteria (date) at run time which then pulls back records where the AdmissionDate is < the criteria date and the DischargeDate is > the...

I have a query that produces data on many lines due to a one to many relationship in the table design. What I have been asked to produce is a flat file with the 'many' part of the relationships as additional fields on the end of the record. They want it in Excel or CSV file. This should maker...

Hi, I need to import a delimited (|) txt file which has 741 fields. I appreciate that access tables can only have 255 fields so need to be able to develop 3 tables that are relational (121). I presume it can only be done through code and by manipulating the txt file first. However I haven't...

I have just created an ODBC and linked over 1000 tables. However for ease of use I want to be able to delete all of the tables where there are no records (100s). Can someone advise me of how to do this with code in a module? Thanks in advance Jonathan

I have labels and text fields on a report that when I put them to vertical orientation go blank. I have just had IE7 installed and did not have a problem prior to this. I have googled the problem but not seen any specific reference to MS Access (although lots within other applications). Does...

I want to be able to hide the page footer when the report footer is on the page. Any ideas? The reason is that on the page footer I have a 'Key' for the report that could span multiple pages if there are enough records. What I then have set up is the Force New Page as Before Section on the...

I have a strange problem where I have an SQL query which runs great until I add one particular field. The SQL that works is SELECT tblCluster.ClusterDesc, tblTeam.TeamDesc, tblProfRole.ProfRoleDesc, tblProfRole.ClinicalLevel, tblPatient.PatientID, Count(tblLTC.LTCDesc) AS CountOfLTCDesc FROM...

I have a treeview control that I am loading with data. When opening the form it always expands the second node of the first level. I am confused as why it is doing this. I want the form to open with all nodes collapsed and the first node having focus (but not expanded). Can somebody help...

I have my tables set up so that a client can only have one of any particular product. My front end on Access throws up an error about a violation of the primary key when a user attempts to add the same thing for a second time. However, I want to be able to trap the error and provide a custom...

I have a database that stores assessments. It is basically a field to link to a table called tblPatient, a date field and 24 question fields. When a new assessment is done it will only usually be 1 to 2 answers to questions that will have changed. The rest are the same as the last assessment...

I am new to using the treeview control. Can anybody help with the following? 1) How do you make the currently selected nodes text Bold or a different colour? (because the highlighting of a node disappears when the treeview control loses focus) 2) On the On-Click event of a node how can you...

Apostrophe added during code -------------------------------------------------------------------------------- I am trying to create an excel file from code within an Access database. When I use the following line in my code it works but comes out as =Sum('D22':'D35') .ActiveSheet.Range("D" &...

I have managed to populate my treeview control. What I now want to do is to add a record in the underlying table, refresh/reload the treeview control (to show the added record) and then return to the same node that I was on prior to adding the new record. I can do the refresh and reload on the...

Not sure why this is happening but when I comment out my error handling the code fails silently (i.e. no debug window). When I have error handling it does trap the errors. This is OK if I know the errors to trap for but does not help when testing code. Does anybody know why Access would stop...

I have the following select query which I would then like to use to update a table with a value. I keep getting 'Operation must use an updateable query' error message. SELECT CouncilData.EntSys, CouncilData.ASS_CODE, CouncilData.ASS_DATE_TIME, Min(CLIENT_ASS_TAB_DETAILS.TAB_DATE) AS [Date...

I'm changing th eSQL of a crosstab query on the fly (querydef). However every time I do it the Column Headings setting of the query gets lost. Can you keep this or program it through VBA. My SQL for the query is TRANSFORM...