Hi Guys
I create a new form with vb code that will allow me to send emails with an attached pdf report, it is working fine, i installed in 4 pcs, for some reason one of them is not working ...
I am try to create a dataset using the code listed below. Seems that if I do not specifically name the querydef, there is no way to then open the query (works for action or update queries onl...
Dear Experts.
I am making an Access 2003 staff database & have a form (Frm_People) which contains a sub form (Sub_Form_Skills) and also a list box of the skills attributed to that member of...
I have a form on which I want to cancel the close form event if one of the form's text boxes has a certain value. I have two fields in the detail section, and in the footer I have txt_sum whi...
I'm trying to perform what I think is a simple query. I have a query that consolidates and cleans up several pieces of information from a table. I then want to be able to further segregate/r...
I have a problem with one of the MSAccess processes that I have ran every night for several years. We updated our ERP software (JD Edwards) from SQL 2000 to SQL 2008. Now when I go into Get Ex...
I NEED TO WRITE AN "IIF" STATEMENT IN A MS ACCESS QUERY THAT LOOKS FOR THE SYMBOL "*#*" [WHICH IS A WILDCARD] IN AN ADDRESS FIELD. IF THE VALUE EXISTS, THEN IT IS CATEGORIED DIFFERENTLY. THE...
My app used to import from XLS files for years. These XLS files had been received from several banks. One morning the banks changed the format of their XLS files: each XLS is accompanied by 4 ...
Hi EE,
Do you have code to loop through a folder
(I will modify the file name)
then copy to another target folder.
thx for your help, s
Hi,
I'm having a complete brain fried moment, and I'm fairly sure this shouldn't prove to difficult for anyone here (though I may be wrong). I am trying to add a bit map to a field in a tabl...
printing a word document through MS Access 2003 vba using a specific printer chosen by user from the print dialog..
This is the code I have, can't figure where I am going wrong or is there ...
Hi everyone,
I have a UI program created using vb.net which displays data from an ms access 2007 database. On my form, i have a datagridview to display the contents of the database.
To m...
Hi:
Please see the code down there>
I have at least 4 rows with AttendanceGregorianDate = #04/10/2009#
But I always get Dcount = 0 when I enter #04/10/2009# at Me.AttendanceGregorianDate
W...
I am working on a Microsoft Access database that was created in Microsoft Access 2003. The users are now using Access 2007 and we are developing in 2007. However, the custom toolbars the ori...
Hello,
I am new here and new to access. I need to calculate the fiscal quarter that I am in based upon the current date and automatically insert it as a default value in a text box in a ...
I 'm working on a project that requires calculating patient days by month. Problem is there are some patients that are in the hospital for several months. For instance, 1 patient may be admitt...
I have a form I've been creating in access, and all the sudden when I open it it's blank, and I can't even scroll down, all it shows is the header, yet in design view everything still looks ri...
I have a Dlookup
DLookUp("ProviderName","tblProviders","ProvidersID = " & DLookUp("ProvidersID","tblCorporateClientCompBenefits","CorporateID = " & [corporateid] & " and CompanyBenefitID=6"...
i am trying to insert data into a table, however the data contains an & sign
in the string. Oracle dosnt allow me to use it as an ordinary character,
instead it uses it as a substitution var...
I have a database with two tables. One is called Repair Description, the other, parts list. Repair description contains the following fields:
-ID
-Date
-Equipment Number
-Repair Type
-I...
Hello Everyone,
I built a Make Table Query (the SQL Version is in the Code Section) which work fine but I wanted to give the flexibility to my user to save the table in new database. So what ...
Experts,
I have an Access table that was imported from a proprietary program. It comes across with blank cells in some of the records. Is there a way without exporting it to Excel to popu...
Hello Experts,
I'm using Access 2007 under Windows XP version 2002 SP3.
I am writing a very simple Access application with no tables, no reports, just one form with one button it.
Aft...
I have been tasked with developing VBA script to automate a Access DB that is used on a regular basis. This DB consists of a large number of queries that have to be run sequentially to achieve...
Hi Experts,
I'm not sure what to do. I'm creating a pop up reminder, in the reminder, I have four different tables, example, on table1, I have completion date and Comply date, if the complet...
