Search results

Good Afternoon, I am trying to run some diagnostics on my database. I thought a good place to start would be to look at all of the tables, the number of records each table holds, and each table's size. I have been able to find plenty of code on the web that loops through each table and...

Hello, I have a form with 7 unbound text boxes on it. The code below is on an On Click event of a button. The code is supposed to look at all of the unbound text boxes, if they are null make them a 0, and then conduct a simple subtraction calculation. For some reason the Nz(stringhere,"0")...

Good Afternoon, I am in the middle of creating a function that populates two unbound text boxes on a form and then uses those unbound textboxes in a query (Total of 3 unbound text boxes - 2 are populated from this function). The saved query object is working fine when I manually execute it...

Good Morning and thank you in advance for any assistance provided - I have a main form, lets call it FrmMain. In addition, I have a subform on FrmMain that has a tab control on it (frmSubform). What I would like to do is on form load, reference the tab control that is on the subform, loop...

Hello, I am trying to create a small function that looks that a date field, finds the current calendar quarter, and then returns the previous quarter. I came up with the code below, however, because I subtract 1, when we are in quarter 1, the function/string returns 0. Any ideas how I can get...

Hello, I have the following code that checks to make sure associates, other than myself, are not accessing my Access database from the main share-drive location and that the associates are using a local copy on their desktop. The code was originally writtien so that I - the main developer -...

Hello - I am using the following query to pull a list of all tables in my database that are connected using an ODBC connection: SELECT MSysObjects.DateCreate, MSysObjects.DateUpdate, MSysObjects.Name, MSysObjects.Type FROM MSysObjects WHERE (((MSysObjects.Type)=4)); I need to take this...

Hello, I need to run a query and export it to Excel in a certain format. The format needs to be something like: Account, blank1, blank2, Client_Name, Address, etc, etc The problem I am having is getting the blank columns to have blank headers. Is there a work around to get a column to be...

Hello All - Have any of you ever had an issue where your code will work on a double click Event, but not a single click event? The code listed below is doing this to me and for the life of me I cannot figure it out! The error that I am getting is "Object Variable or With Block Variable Not...

Hey All, I am having a horrible time trying to get 3 unbound text boxes to insert into one list box with three different columns. I am essentially setting the information in the unbound text boxes to strings and then trying to add the strings into the value list, list box. For example...

Hey Guys, It has been a while. Hope all are well. I am working on trying to get a date field on my subform to turn red when the date that the field list is > 30 days. In the expression section of conditional formatting I have tried: DateDiff("d",Date(),"Dt_Approved")>"30" Any...

Good Morning, Has anyone ever had issues with a AutoNumber field duping on them? I have a table that every morning about 200 records are inserted into the table. I noticed that I actually have dupes in my auto number field. I did not think that was possibble? Has this ever happened to...

Hey Guys, I have an auto email that is sent using Access 2007 VBA. I am trying to add a header and a footer image to the top and bottom of the email to make its appearence more professional. I have heard there is a way to convert an image into an HTML code then use a function to bring it...

Good Morning, I am working on my first list box. Currently an associate selects an acct number and clicks a button. The code below fills the list box. it is only one field. [SELECT DISTINCT Test1.ID FROM Test1 WHERE (((test1.acct_nbr)='12345678')); What I really need to happen is to have...

Good Morning All, I have an Access 2007 database that associates will be sending emails from. The email is going to be rather lengthy. Basically it will say: This issue has occurred because of "reason". I am trying to figure out how to make it where the reader of the email can click on...

Good Morning All, I have a subform that is linked to a "notes" table. What I need to happen is if one of the notes is like "*Approved*" then the notes_field on the subform turns green. I have tried the conditional formatting setting that Access 2007 provides but I am thinking I may need to...

Hello, I have a querydef which a report is based off of. The query is created, the report is opened based off the query and then the query is deleted. I am having an issue when the report is long enough to reach two pages it only displays the first page of the report. I have the report to...

Hello, I have a query that a report is based off of. The issue is the report is not showing all of the information. It only displays the first page of records. The report should be about eight pages long. Any ideas why this would be?? The code to opent report is: docmd.OpenReport...

Good Afternoon All, I think I have an easy quesiton but cannot seem to figure this one out. I have a mailmerge set up that looks at a "pending" field in a temp table. if the pending field is = "test1" then it grabs a letter1 and saves it to the share drive. The problem is the code loops...

Hello, I am trying to conduct a mailmerge by calling a function. Basically the main table "60_Day_Clientlettertbl" has a "pending_notes" field. Depending on the pending field one of two letters needs to populate. Once the code determines which letter to use it calls a function. This is the...