Hot Solutions

after fighting for hours with a fax solution - I opted for automating the process of emailing the necessary documents.

I created a Macro for this purpose with code that opens Outlook and closes outlook after it is finished .. and that works...

Hello,

Old printer was EPSON TM-T88II POS Printer with Parallel Interface, connected to LPT1.  VB6 code:
 

Now printer is EPSON TM-T88V POS Printer with USB Interface, connected to ESDPRT001.  This VB6 Code fails:
 

I need to print to...

Hi Experts!

My apology for question not being  clear, as any perfectly formulated question by itself shows an answer.

Im designing database in SQL Server. Not taking into consideration all other Entities, I have two. One entity is...

Hi All,

Looking for what I have wrong here. I am have built a macro to export data from a table, then run a delete query to remove the records. I need to save the export by date (this routine will run nightly) The Output File is set to ...

Does anyone know how to determine what the key field(s) are for a logical file on an AS/400 from a query?

I am linking from MS Access with VBA and I need to specify the keys in order to update.

I would like to know if it is possible to use Filemaker Pro 11 to "check out" assets (e.g. computers, printers, etc.) to users.

I would like to be able to scan user's badges and pull up their information, what assets they've had checked out...

How do I find out number of records returned by web query in MS Access web database published on SharePoint 2010

Hello,

i'm searching a way to get a list of running application in Delphi XE2 win32
I have found a lot of code on the web but all of them are showing how to list "process"

I really need to get the list of running application like the...

Hi Team,

I want to transfer a table from Access to Excel and the number of records are more than 65,000.  I tried using the "DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9", but it transfers to Excel 2000 version which has only...

In previous version of MS ACCESS such as 2003, I was able to setup security users and create a workgroup.  Users would need to use password to login and I can easily reference the users who logged in.

With ACCESS 2010, that feature of create...

Hi Experts, I have been given an assignment of taking a list of addresses and determining the lat/lon for them.  I'm at a bit of a loss as to how this can be accomplished.  I did see a previously entered note here which did the job in HTML for a...

We have a MSAccess 2000 compatible database running in MSAccess 2007.  A table in Sql Server 2008 R2 is linked via odbc.  This table has a bigint field as the primary key and in MSAccess we only see #deleted in every column, every row.

The...

We have a database that was developed using Microsoft Access 2003 and then was migrated a couple of years back to Access 2007. It ran fine for years.

This past week, we upgraded to Access 2010 and the database appeared to be running fine, all...

I am trying to run an Access 2010 module as a daily Scheduled Task on a Windows 7 Professional operating system.
This will run at night when my computer is logged off.  

I have the Action: Start a program
Settings
Program/script:...

Hi All,

I have a function that deletes records from a table based on the records selected in a list box control on a user form.

Enclosed are two functions, one (collectDeleteRDCArray) that collects the data for deletion from a listbox...

I am new to Access 2010, and I'm not a developer or advanced user.  I know how to import external data (Excel, txt files, etc) to create new tables or append data to existing tables.  I would like to make this a 'push-button'/menu type action...

I have a table that I need to update (append records) daily from a delimited text file.  I know how to do this with a form button that runs VBA code, but I would like to schedule this task to run automatically every day.  I am not a programmer or...

Hello,

I have an excel file that needs the address separated, Basically i need the zip and State and city  removed from the column and each need to be in its own column. As you can see in the attached example i don't really have a consistent...

I am moving data from one program to another program. this involves exporting the data to a CSv file. Then I open the CSv file with excel. then I edit the data. then I resave as CSv file and import the data to the new program. when I export the...

Hi All,

I've had a search and I realise there are some posts on this but I'm afraid I can't work out what's wrong.

I'm getting this error:- Only public user defined types defined in public object modules can be used as parameters or return...

Hi:

We're creating a web application with VS 2010 using Visual Basic.

We'd like to update an access database table using OldeDb...

For some reason, when we run the code, the program hanged and a message: "syntax error in WHERE clause".
...

I have an MS Access Application running in MS Access 2003 which connects to a 2000 format database file.  I have the locking set to Edited Record level and ticked the open databases with record level locking.

However, I am still getting page...

Hi Experts,

I have a query in Excel which I regularly export to Excel using VBA. I would like to automatically apply a Theme (a Table Style) when it exports to Excel so that the background color of the rows are alternating. How do I do that?
...

I have a split database that was giving to me to modify. I am having problems with making a report. The only way I can get help is to show the database to one of you experts. The linked tables are on the C drive. I copied those to my external...

Hi guys,


I am using vb.net and access 2010 database.

I am using an insert statement to send a double value from a grid-view cell to an access database.

The cell contains a double value.

The problem is i am able to send the values...

I am using Access 2010 and vb to do a Recursive Folder Search in all subdirectories looking for a file that starts with a character string.  The code below does find the file name (vFile).  

Once found, I want to insert the item (strPN) and...

Is there a difference if a variable is dimentioned as:
Global gstrUserID   vs  strUserID
when declared at the top of a module (not a form or report module)?  I want the variable to be used throughout the application.

Sandra

I'm trying to migrate some queries over to SQL from Access.  I'm having trouble replicating the following in SQL:

Relist: DateDiff("d",Now(),DateAdd("d",31,[Uploaded_date]))

Any ideas?

Hi:

We're creating some web application using VS 2010 with Visual Basic.

We try to insert a new record into an ACCESS table, or update/delete an existing record using DetailsView associated with AccessDataSource

We configure DetailsView...

I know that this...

Private Sub Command92_Click()
Me.Date_Paid = Date
End Sub

Gives me the current date but how would I rig it to give me a date 1 year in the future?

Thanks

I've found this function that I use for uploading a database file to a FTP server, and it works fine. But I need to have an additional parameter in the function, so that after uploading the file to the folder indicated by the sDir paramter, it...

Please help!  I have been banging my head against the wall for  days.  I cannot figure out why this all of the sudden started happening.  I am well aware of the breaking change sp1 win7 does to MDAC and I've posted ad naseum in those threads...

I have a form with an unbound Combo Box that gets its value from a sql string,
I have a sub form SubfrmCAT_SUBResultsForAttrib that I want to filter by the value in the Combo box.  There is no parent child relationship between the sub form and...

Hi,

I have an eCommerce System I built using access which I have used for several years an dfits most of my needs, apart from 1, the ability to send sales emails direct from access with different from address's depending on the website the...

I'm trying to use a command line tool called pdf toolkit to merge files in VBA.
I've successfully run it in a command window so I thought it would be easy to call a shell to run it in vba.
 

This runs without error but does not create the...

I was able to convert a date field that was in text format to date by using this query in Access

UPDATE
  tblYourTable
SET
  NewDate = IIf(IsDate(Format([TextDate],"!@@@@/@@/@@")),CDate(Format([TextDate],"!@@@@/@@/@@")),Null)

How would I...

Can someone give me a practical explanation for the uses of single, double, Integer and long integer with some examples.
I can't seem to put my hands around these things.

I am using Access 2010 and vb to scroll through the values in a table (tblItems) and read each record (Item)
The string is used to a Recursive Folder Search in all subdirectories looking for a file that starts with a character string.

The...

I'm having trouble connecting to a Table held in a Microsoft Access DB by using Powershell as the language to connect. The issue comes into play by the uid and pwd commands. This is what is causing the issue. If I were to issue the command...

Hi

I converted an Access 2003 app which had a progress bar to Access 2010 (64 bit on a 64 bit Vista laptop), that "old" progress bar doesn't work any more. How/where do I get a progress bar for Access 2010 ? I did not find any in the toolbox....

Hi:

On the KeyDown event, I want my Access form to see that the user has pressed the Shit and Ctrl and Alt and F5 keys simultaneously.  If this has occurred then

me.CompletionDate = Null

No idea how to use or call the custom key...

How can I increase the font size of the email inbox?  I don't want to change my screen resolution. Just my outlook.

I have a database with a toolbar menu that was created in Access 2003. A user clicked and dragged the menu off of the top part of the window then clicked X to close it. I cannot figure out how to get the menu back on their machine.

The menu...

Hi,

I have 2 tables: tb_initdata(with 3 colums - ID, Name, Type) and tb_new(with 2 colums - ID, Product). I need a mysql query to update the table tb_initdata(column Name) with data from tb_new(column Product) where the ID columns are equals....

Microsoft Office 2010 using an .adp file to connect to a SQL Server 2008 R2.

When trying to make modifications (increasing column size, setting/removing PK's/identity) we randomly come across the following error:


ADO error: Incorrect...

Syntax Error (Missing Operator) in query expression 'BNo = '

in B_Detail Table
BNo ( Data Type is Number  and  Field size is Double

 

Why i am getting this error

i have exchange 2010.  most of my users have outlook 2007 or 2010

i need an internal link or any sorta that will start their outlook, put an email address in the to box, populate the subject, and... insert a form into the body of the email...

Hi Experts'

I am getting an error in form wizard when I try to create a form and sub form when I add the second (sub) information and click next, I get the error listed below. The customer is the primary table and the contract is the sub....

Hi,

How can I create new database or export db from access 2007 in sql server 2008 express?

thanks

ayha

I am trying to help someeone with a problem on one of their forms.  the data source for the unbound text box is one of the fields in teh query for the list box.  When teh user changes the list box selection, the items on the form update with the...

I have a string that occasionally contains a '<' with out a space following it, I need to create a function that will add a space following the '<' character, the additional constraints I'm dealing with is that there may be '<' with a space...

Is there away to calculate the person's age and to show up in the TABLE not a query.  I have created a query to caculate the age but I want it to show up in the table.  Is that possible, if so how?
the function I used for the query I created is...

Hi there,

I have managed to get code to utilise the balloon tooltip function from MS Access which works great with no problems. What I am struggling with is making the pop up appear on all the front end applications when a user creates a new...

Hi EE

I am trying to increase a numbe by 1 each time it's used this is the type of number
DEMO00001. It will always have 5 digits sample of other numbers are
CI00001
RD00001
ST00001
I am using the following function

rsjob.Edit
...

I have VBA code that sends PDF documents, if I check the document before sending it looks fine but the recipient receives a corrupted version (Black lines and some pages completely black). BTW we use Exchange 2007

 Set objMessage =...

I am trying to use CryptoAPI using VBA 7 in a Windows 7,  64 bit environment.  Will this ever work?  I am trying to use Cryptography for Visual Basics by Richard Bondi but this is not working.  I getting type mismatch on CryptImportKey function...

The VBA editor seems so limited, yet I have not found any alternative other than copy the code into another editor, edit it, paste it back. Yuk!

There must be a better way! Please help me find it.

Below is the TSQL we currently use to import data from an archived Access MDB file on a Windows XP remote PC.

Every night the shipping sofware exports the days shipments into an access mdb with the following name formate mm-dd-yy.mdb

I use...

Hello Experts,

I have an Access 2010 database (backend) with 16 tables, on which I'm trying to use the Upsizing Wizard to SQL Express 2008 R2.

15 out of 16 tables upsize successfully, however for one particular table I keep receiving the...

I want to start using VBA modules (something I have never done before), but the "Modules" group does not show in the Navigation Pane along with Tables, Forms, Queries, Macros, etc.

I verified carefully that it is checked in the Navigation...

Hi,

I am trying to display the following data on the combo box.

departmentID, institutioname, departmentname

Column count 3
Column width 0;3;3
Bound Column 1

I want to see both institution and departmen name when I click it.
But...

I've worked with tab and comma-delimited data but never XML data files.  
Where would you see XML used?  
Are there applications that are particularly XML-friendly?  
Are there industries that prefer XML?  
Perhaps particular web sites?

I used this statement with numbers and had no problem but trying to match text and it does not seam to work.  

 

I have inherited a database with 311 queries.  Is there a way to simply loop through all the queries and have them printed out?  I am trying to "cleanup" this database and am trying to figure out where all the tables are used (or not as about 25%...

dbse uploaded
see form called files

what i am trying to do and failing is to have a combo box that when selected with colleagues names restricts or filters those records shown to that colleague.
any pratical help welcome

When I run the below code in Access 2003 for Word Mail Merge I get the box asking me to select table  (In Graphic MailMerge-Problem.jpg)  when I set the spreadsheet as the source.

.MailMerge.OpenDataSource Name:="C:\a_MailMerge.xls",...

I have an ACCESS 2003 database that I am using to open other databases.  This "menu" database only has one form and on that button that open other databases.  However, I am trying to set up the first database and while the "child" database has an...

Why my outlook 2010 became very slow how to make it fast

Hi Experts,

Really struggling to get my head round all this and my boss is needing a solution!

We have an access front end, with tables currently on a XP pro machine running SQL express.
Our database is currently 1gb large and can be used...

I am looking for an option to publish a complete access 2010 database to the web. I need about 5 users to work concurrently of the web interface. The database contains linked tables, queries, reports and some fairly complex formulas. I have heard...

Hi.  I am hoping someone out there can help me with a problem i am experiencing with a MS Access 2010 adp file.  When I open it, it up with the following error message:

<adp name> can't open the form <form name>
It contains data that <adp...

Hi:

We're creating some web application using VS 2010 with Visual Basic.

We try to update/delete an existing record using DetailsView associated with AccessDataSource

We configure DetailsView to bind with the AccessDataSource and also...

In Outlook 2010, I have access to another's calendar. When I want to put a new appointment on their calendar, I get a form that wants me to send them an invitation to a meeting. But I don't want to send them anything, I just want to put the...

I had a query that combined two separate queries so that I could have all of the records in one table.  Basically the table is from the quickbooks backend database.  It contains a table for transfers with both the from and to accounts.  I was...

What is the level of relationship between Access 2010 and Outlook 2010 Calendar.  Im looking to be able to develop appointment bookings in Access and the appointment also being added to Outlook?

I have a database created in MS Access 2010 - File Format is Access 2007, New Database Sort order is General - Legacy.  When my client tries to run in MS Access 2007, he's getting an unrecognized file format error.

I thought DB settings as...

Hi EE

I have just installed a new app onto 4 PC's but on two of them I have a strange problem the list box's wont populate they are set up in the usual way linked to eithe a tbl or query. There is absolutely no difference between the 4 pc's....

I am trying to requery for the combo box in another form.

I have two forms.
frmPublication/frmqryAffiliatiion_subform
frmAuthor

When I adda new record in the frmAuthor, I want to requery the combo box in the subform of the frmPublication....

I am currently using an query that uses the "like" expression.   Looks like this:

WHERE (((multiple4active.ShortTitle) Like "*" & [Enter a key word or Partial key word] & "*"));

I want to be about to pass a variable for a field name on a...

I've got an MS Access DB that sends and tracks LN emails.   Right now it works only by sending emails from my account, i.e., the one associated with my LN client login on my machine.

I would like to do these functions using a group mail box...

Not sure if this is possible, but I wanted to use a FillBy query to populate a datagridview on a form I have.  The issue I have is with the Where clause.  If I hard code the item to lookup it works fine

Where TrustName = 'Smith Trust'

I run...

Hi,

I need to secure an Access database with different users having different access to different areas.  Now that Access 2010 doesn't provide User Level Security, what is the best practice?

Can the front-end open an encrypted back-end in a...

Hi. I need to get a range eg "A2:B6" after the user selects it. The problem is that the following code returns "$A$2:$B$6. The $ signs cause errors

            Dim R As Microsoft.Office.Interop.Excel.Range
            Dim A As String

     ...

Logic trying to implement in an MS query (avoiding VBA in this case):
If Field1 = "300", then Field2 = 0, otherwise Field2 remains what it is.

The syntax I've tried is:
IIf([Field1]="300",0,[Field2])

When I run this, I get all the Field2...

We want to automate the process of importing a few tables from QuickBooks to Microsoft Access using Access VB. Can this be done if so how. Please advise.

I ask this for senior expert mlmcc .......because he told me to...!

Is it possible to write a VBA script within Access such that when the script is finished, it can exit Access and specify an Exit Code?  

The only thing I've found is to execute the ExitProcess API, but from what I've been able to find online...

Hi Experts,
I have users that assigned to their own defaul printer (every user has different printer IP), however, I have a report that I would like all the users can print from one specific printer (not the one that they assigned to) and not...

Hello,

I have a MS Access with a lot of forms and reports that is connected to a SQL Server backend.  This has been working out ok for some years.  However, since everyone in the office is on a MAC, I would like to make the front end to the...

Using Excel 2010, how can I show the numeric POSITION value of the Row and Column of a cell I select? Note I'm not talking about the value of the data stored in that Cell, but rather the position of the cell itself.

For example, if I select...

I have developed an Access 2007 "project" (.ADP) as a front-end to a SQL-Server 2005 Express database.

On each of my client's PCs I have installed a free "run-time" version of Access 2007 and an ".ADE" version of my Access application. The...

dbse uploaded

go to form called files-see subform

i am trying todouble click on a client index record in the subform to open the corresponding record in the clients1 form.

but access cannit find the form.
there is s syntax error in the...

Can you please help me to add values dynamically to listbox columns.?

The following code giving me an error (2nd line) "Object required"

Me.List_Box_Account.AddItem "my vlaue a1"
            Me.List_Box_Account.Column(0, 1) = "my value...

(Note: PC specs at end)

Hello. I write and sell an application that’s a VB6 front end on an Access backend. It’s designed to be multi user and used over a small business network, although in all the tests I’ve done I’ve used the DB on the PC’s...

I am using the following code to try to print to a named printer but it keeps printing to my default.  Please help.
thank you,
Jeff

 

Hi Experts,

I have an Access UI with SQL BE, but I keep getting

Syntax error (missing operator) in query expression 'Cast(fldReservComment as NVarChar(4000)) = '3/6/2012 1:15:51 PM''.

with



However, when I execute the above under...

Hi Experts,

In Access VBA there are two commands used for the reports.

acViewPreview and acViewReport, could you please give the difference between both the commands.

Thanks in advance.

I have had a brain lapse.  Just need the translation of this statement.

Expr1: IIf(Mid([Date1],2,1)="/",Left([Date1],1),Left([Date1],2))

It is the  first part I having trouble with.  

I believe it says      If Second position = “/” then...

dbse uploaded
go to forms
go to files
i have two combo boxes.
the first filters by colleague
thev second should filter by file status
i have tried to link the two by some code in the second boxes after update event but
i have gone wrong....