Search results

The basic interpretation for your third column would be as follows (the "d" tag measures the date difference in days): DateDiff("d",[DateReceived],[DateClosed]) If you want to add an exception that handles records with no closed date, use this one (optionally, if you just want to look at...

The input mask would be 99/99/0000;0;_ As far as a calendar control, I have seen several examples of this mentioned previously on the forums... try http://www.mvps.org/access/forms/frm0050.htm for a solution good luck...

The easiest way to do this would be a function (code) IF the file name will always be the same, you can write it like this: First you need to manually import the delimited file once... once you fixed all of the fields/data types, click on Advanced and save the inport specs as IMPORT_FILE or...

yes, you can join tables together into a single query... create a new query, add all of the tables you wish to combine, and then link the tables according to your primary key, or related fields as far as your second question, My understanding is that Access does not have a record limit, rather...

Create a query & use the "totals" function... add the fields you want to see, Select "totals" from the View menu, and then select the type of totals you wish to see. Group By is the default, andyou can do sum, count, Expression, etc. Once your query is correct, change the query type to "Make...

If you want to ignore whatever is in front of or after the user name, try Like "*" & [Enter User Name] & "*" OR If you want to search only the memo fields that have "Placed_By: " use Like "Placed_By: " & [Enter User Name] & "*"

immediately I see that you have stLinkCriteria as a specification, but you don't have a value defined... you need to add the variable... something like stLinkCriteria = "[primaryID]=" & Me![controlname] replace "primaryID" with the linked primary key & control name with the field on your...

could you post the code you are using on the OnClick event of the button? I really could only take a guess without it...

finally found an article that deals with this issue: http://support.microsoft.com/support/kb/articles/Q245/4/07.ASP

I see what you are saying... and you're absolutely correct. The dbase files are just .DBF files, not an actual database connection... I was using the wrong argument... I didn;t realize I would simply use the text option for .dbf, and it works perfectly now... Thanks!

hello all, I'm writing a procedure that transfers an error log (the log is in text format) into an Access table, so that users can generate summary reports an analyze generated errors I've written the import specs, and they work fine. The only problem is, the error log is written...

Just a "curiosity question," (I'll use it if it's possible) Is there a way to have a single report toggle between portrait and landscape based on the section being printed? By this I mean for example, a charges report would have 2-3 summary pages, and then once the detail section comes up, the...

Hello all, My VBA journey continues... I wrote the code shown below for a form... what is intended to happen is that a user selects two dbf files from their computer and then once they do, the transfer database procedure runs and imports the files they have selected. I keep getting an...

there is. Method #1 Add a text box to your report field and set the control source like the following: =[Enter Information Here:] replace "Information Here" with the prompt you want the user to see. This will cause a box to pop up any time the report is opened, querying the user to enter the...

try referencing the main form, then the subform (that is the problem I always run into): .ActiveDocument.Bookmarks("percentaccount").Select .Selection.Text = (CStr(Forms![mainform]![subform]![child86]))

F11 opens the database window CTRL + F11 opens the menu bar SHIFT + F10 shows the shortcut menu

It's not the IIF part, you have that correct... try changing the statement to IIF(IsNull([srm_memo]),"","Update") ...and it should work fine

I'm not exactly sure what you mean by "open" Suspense date... if you mean where there is no Suspense date, the you would use "Is Null" as the criteria on that field (excluding quotes). If you're looking for something else within the Suspense field, please clarify, I'm sure we can fix it.

This isn't somethingI absolutely have to do, but I thought it would be a nice addition if it's possible... I have several search results forms that use list boxes to display data. I would really like to be able to turn the column heads into "buttons"... and when a user clicks on the column...

That was EXACTLY what I needed... THANK YOU!!