Recent content by thr33xx

Any ideas guys? This works for print preview, but not for report view.

Sorry, I forgot to clarify. There are multiple records on this report. The above method I mentioned does work on the multiple records. Where it will hide if the status is not published, and show if published. I just can't get it to work in the Report View.

Hello, I am working on a report in which I have 2 fields in the detail section. The field names are "Status" and "Citation". When viewing the report, IF the status = "Published" THEN I would like the Citation to be visible, ELSE the citation should be hidden. I was able to get the print...

Wow, that was quick! Thanks, Bob. Looks like that article is exactly what I'm looking for.

Hello all, I have a query which provides a Project_ID and Name. I would like to take this query, and have it create insert into a temporary table, which then will add all of the names of the same Project_ID to a single cell (column/row) with the related project_id next to it. My understanding...

thanks bob!

I have the following code which generates from Access to output to an excel file. I would like to make the font of the entire document font size 8. I am able to do this for the headers and select cells, but how would I got about applying this to the entire sheet or file (including data). With...

Great. Thanks.

Hello, I am working on a form which allows users to modify changes to a Study. This form contains values, which if changed or modified, have the potential to change the way the metrics are changed. For that reason, there are 6 values that must be checked before the data is changed. I have the...

Here's what the code looks like. Private Sub Add_New_Study_Click() Dim cn As ADODB.Connection Set cn = CurrentProject.AccessConnection Dim rs As ADODB.Recordset Set rs = New ADODB.Recordset rs.ActiveConnection = cn Dim sql As String Dim sql2 As String Dim var_item As Variant Dim ctl As Control...

Hello all, I am trying to figure out how to code this loop efficiently and effectively, and below is what I've come up with, but I'm not exactly sure how to execute it. The code below is performing the function of taking the remainder of a calculated value (MOD), and adding the remainder to...

Alright, I think I understand. However, how do I get the Dcount to work if I am using Dateserial which is pulling values from fields on the form? My understanding with Dcount is as follows, DCount ( expression, domain, [criteria] ) However, I am not using a domain/table. Is there a way to not...

Sorry, I don't see how I would make use of the DCount function, as I am not trying to get a count, but I am trying to enforce a validation and make sure that the date added (month/year) is between the start date (month/day/year) and end date (month/day/year). The problem I am having is how to go...

Hello, I have a database which users input multiple date records which contain month/year. In addition, there are two specific dates which are entered into the database, a start and end date (which are month/day/year). All records that the user enters (month/year) must fall between the range...

Figured it out! Silly comma somehow slipped itself in there! I know I didn't type it! ;) Private Sub Add_New_Study_Click() Dim sqlstr As String Dim cn As ADODB.Connection Set cn = CurrentProject.Connection 'Updates/Save changes to study info sqlstr = "Update dbo_Setup " sqlstr = sqlstr &...