Search results

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...

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...

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...

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...

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...

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...

I am running into the following error when attempting to execute an update on some fields. I receive the following error, "Run-time error '-2147217900 (80040e14)': Syntax error in UPDATE statement." Here is the following code being executed. With the highlighted being the issue. I have also...

I am attempting to relink a handful of pass through queries. I have found the following codes to relink the queries, though I am unsure of how to use them. Could somemone provide some insight as to how I would get these queries updated using either of the codes below? More specifically, where do...

Still learning VBA, so please bear with me. I have an If Then Statement which if the criteria is true, it executes, otherwise it should do nothing. When I execute the code (click the add record button), the following error results when the value is 2 or Null or blank, Run-time error...

I am attempting to create a text field after update validation to check to see if a study id already exists. If it does, a warning message will appear informing the user that such a study already exist. Below is the code I have, however, upon execution, I receive the error, Run-time error...

I am attempting to add a specified amount of time (months elapsed) to an already existing value. However when the code executes, it returns values as if it is ignoring the "specified" amount of time which I have bolded below. Any ideas? sql3 = sql3 & ", " & Month(DateAdd("m", I - 1...

Keep getting, "Compile error: Block If without End If" Any help for a VB newbie would be greatly appreciated! Thanks! If Me.Add_Recruitment_Started = "Yes" Then Monthstoadd = (Me.Add_Exp_Num_Mon_Enroll - Me.Add_Study_Months_Elapsed) Numtoenroll = (Me.Add_Tot_Target_Enroll -...

Hello everyone, I have a form which contains a single multiselection listbox. The listbox houses values of different facilities. I would like users to be able to select all applicable facilities pertaining to that record (could be 1 or more), and then click a button which would insert the...

I have a form which has a tab control in it. By default the tab control has a white to sand gradient color background, from the tabs to the tab control background. I can't seem to figure out how to change the color. I have tried the properties, along with the shape fill. When I select shape fill...

I am in the process of migrating over a database from 2002 to 2010. One of the things I noticed different with 2010, is that Access will name tables using underscores e.g. dbo_asys_Employee. Whereas 2002 will use periods e.g. dbo.asys.Employee. What are the implications and issues that may...

Hello all, I am still learning VB so I apologize if this comes across as a mindless request. I am implementing a range check for a data entry database. I am asking the user to input the month. If they enter anything >12 then the msgbox pops up, with vbRetry clearing the invalid value and...

Hello, I have a data entry database which has 4 text fields for data entry. Date | Weight | SBP | DBP I would like to enforce a conditional prompt on 3 of these 4 fields - weight, SBP, and DBP. I would like to setup a conditional prompt where if values entered into these fields are less...

I am just learning Access, so this may be a simple solution that I was unable to find. I have a subform which lists all records for a customer and allows for data entry for a new record. I am currently unable to use my mouse to move the cursor in and out of each field on the record. The only...