Search results

Is it possible to "Edit" a TableDef.Connect value vs Creating a new TableDef with the connection string you desire, then deleting the old TableDef and appending the new TableDef? This would be a TableDef in a remote mdb.

Is there any way of converting MS Access Forms(And module behind) to Visual Studio.Net? I have a pretty comprehensive MS Access DB that has several complex forms. I want to redo this DB App in Visual Studio.Net but don't want to recreate the forms from scratch if there is any way of...

I have a 2K BE mdb (on server) which may have, at any given time, 15 connections from 10ea 2K FE mdb's. Many times users have to end the ACCESS process via Task Manager before they can reopen a FE mdb on their box. What is causing ACCESS not to end it's process the last time the user(s) closed...

What are some good resources on the use of Recordsets via online or print form? I have several books on access and VB but none of them go in depth on recordsets... Crap! I meant to post this thread in the "General" Forum...

I need to print multiple reports (8-12 based on criteria determined by code) and print them in one print job... The key here is I need to send them to a network printer as one job so the printer does not print out a "separator" page for each page of the report. As it stands now, my users are...

I have several textboxes (On a report) who's visible property I set to False with code behind the OnActivate Event... When I print this report via the DoCmd.OpenReport method, all of the textboxes are visible (<--- not desired). When I open the report in Preview the textboxes are not visible...

I need to print a report one time to the user's default printer and then again to another printer... I print the report using a DoCmd.OpenReport "ReportName" behind a Button on a form. Is there a way to change the page setup properties of a report with code? Thanks :)

I need to calculate the amount of days between 2 dates utilizing a "360 day year". Excel has a function named DAYS360() which accomplishes this. Does Access have an equivalent of this or do I have to create a function? Thanks in advance,

I am trying to make a form which calculates what age a person will be on an input date. The date of birth would be already stored in a table for the record displayed. I tried : =Int((Date()-[DOB])/365) but I guess the leap years are messing up the accuracy..... Any ideas??? :)

I have a pretty large DB in the design stages and one of the things I am going to need it to do is generate reports with "spreadsheet like" tables in them. These "spreadsheet like" tables will be generated each time the report is run based on the current client record on a form. There are...

I have a database which I have secured that about 15 users have specific permissions. One of my users has another database they use and one of the queries they use is linked to another database on a different server which is secured as well (via a different workgroup file). After I secured my...

Is it possible to use variables (declared and defined with code) within query fields and/or query criteria? I have tried to do this and haven't had any luck without utilizing an unbound textbox to assign the value of the variable and then refer to the textbox in the query. Seems like a waste...

I have a OLE field in a table which is used for bitmaps (Specifically scanned signatures). On the signature form, I have a bound OLE frame. I set the RecordSource property of the form to a query which gets the signature of the current employee's record. I set the controlSource property of the...

I have a table named "Delegators" which has 2 fields (Employee Name; UserID). I am trying to use code behind an 'After_Update' event of a checkbox named "RFP" on a form named "Employee Authorization Info Form" which is bound by another table named "Employee Authorization Info" to get the...

I am trying to have an image be visible on a Report only when a certain textbox on the report is a certain value.. I tried the code below and I get a Run Time Error '2427' "You entered an expression that has no value." Report Code: --------------------------------- Private Sub...

I have 4 images on a report placed right on top of each other and all of their "Visible" Properties are set to "No". I need to be able to change the property to "Yes" for certain images with respect to certain field criteria. Any Ideas? Thanks in advance!! Mitch

I need to cut the first 3 characters from each record in a field. each record has a total amount of characters. I tried using a combination of the Right() and Len() functions with no luck... EX: =Right([Serial_Number],((Len([Serial_Number])-3)) Any Ideas??? Thanks in advance!!! Mitch

I am using an input box for a password entry for a form to allow edits. Is there any way to keep the input hidden, as a password typically is, as it is typed in the input box? Thanks in advance... Mitch BTW: I am utilizing the code suggested in a previous reply to somebody else's post...

I had a bad habit of when I named tables, querys, forms, modules, and macros, the last part of the name would be what it was... For example: In one database I have about 10 tables and some of the table names are : Emploee Info Table Annex Table License info Table The same thing for the...

I am trying to use a NEXT Statement in the THEN part of an IF/THEN statement and I get an error of "For without Next"... WHY??? Dim strQueryName As String Dim strEmail As String Dim intAnnex As Integer For intAnnex = 2 To 23 Select Case (intAnnex) Case (2)...