Search results

Hi All I hope somewhere here might be able to answer what should be a simple question! We are a Corporate Outlook user so we have all our emails on Several Exhange servers, i dont think this would be an issue but a bit of background doesnt hurt. We have designed a custom Task Form that you...

Hi All I have a little form, that is used for recording time spent on a task, mainly receiving a phonecall. It has other information on it, but for this task we are just working from the start time and end time of a "call" So, i have fields and they have the time in. When the record i want the...

Hi All I have a piece of code that creates an email and sends it out to relevant people, using MS Access 2000. Problem is, i want to be able to add who its from, as we can send emails on other peoples behalf if we have access to their mailbox. Looking in the Objects i cant seem to see one, is...

Hi All I have created a little bit of code, saying depending what field you are in, when you hit a key, it moves you onto the next field in the form. This works great.. However, there are 140 fields on this form, and i dont really want 140 pieces of code, so we thought we would use the...

Hi All Im trialing a new ADP, linking to a SQL database, with 30+ tables in it. I know i can create recordsets and SPs and add to a table that way, but that would take a while with what i have. So, is there anyway of using the MDB code, in an ADP? For a record add my code would be something...

Hi All Im having problems using a bit of code i found, i think from here... im trying to create an ODBC connection upon start up if it doesnt already exist. I can get the connection to be created with all details apart from the password, it doesnt seem to save it! Please could anyone have a...

Hi All Ive written a User Manual for my database, in HTML format. I wanted to use the Help File option of a message box, to have the help button open this file. Ive set the location to a Public Const variable, and then added the Variable into the code, example: MsgBox "Please enter a Paris...

Hi All Im having some Major issues with this problem, i only hope someone can help me!! Firstly, let me set the scene. I have 1 Form, And 1 Subform within that form. The form gets the Main Data, the SubForm gets all the Related Data (in this case, its all the Items Of Equipment this client...

Hi All Im using an access front end to add/amend/get data from SQL Server tables, when opening recordsets you need to use the dbSeeChanges as an option, which i am doing, and for Adds/Edits it works fine, however, when im trying to Get data, i get an error telling me "Data Type MisMatch". So i...

Hi All Im trying to create an Amend Form, which bascially amends a record that is already in the table. I open the recordset with the following code: Dim rstEdit As Recordset Set rstEdit = CurrentDb.OpenRecordset("select * from [eaOTFormDetails] where eaOtFormId = " & Me.OT_FORM_ID...

Hi All Due to our ICT department, we need to bring our databases upto their naming convention standards. I have one database, with over 23000 lines of code behind around 20 forms. I have a table with the [Old Field Name] and [New Field Name] what i want to do, probably using a module is search...

Hi All Ive been trying to do this for the past hour, and failing each time i try! Time to try and pick your brains :) I have a table, called "Clients". This is a list of around 6000 records, with 2 Fields in the table. Field 1 is "PARIS ID" and Field 2 is "SERVICE". Looking Like: 1002154 EA...

Hrmm, im sure there used to be an Excel forum, i seem to have lost it :/ Hope its ok posting here: What im trying to do is, for a range of dates from 1/1/2005 to 31/12/2020 get the Qtrly Financial Period before... So, for instance: A date of 1/1/2005 makes the period before 1/10/2004 to...

Hi, i need to build a string to go into a "IN" statement, im changing the .sql of the query in code, and then opening the updated query. The in statement is built up from 5 Check boxes, depending on what box(s) you tick, the string will be of variable options.. These are my checkbox holding...

I have a number of Const Variables in my database, ranging from strings to integers. However, when im testing, if i hit a code error that isnt caught by my error trapping, it will clear all of the Public and Private Consts. is there anyway i can get it to keep the values, until they are cleared...

Hi All I have written this SQL statement, in VBA to copy data from one table, into a temp holding table. While it copies, it also changes two fields to different reference numbers: CurrentDb.Execute "INSERT INTO [TEMP_VISITS] ( [HH1_MV_VISITS_ID], [HH1_MV_VISIT_DET_ID]...

Hi All Ive had a good search around the forums, and it seems this does get asked quite alot, i found this thread http://www.access-programmers.co.uk/forums/showthread.php?t=28541 which helps me connect to the server and execute the SP, however does anyone know how i could also send Parameter's...

Hi Ive got a continous forum, with several fields on there. They all look at the same table, and are populated after a OnClick event. However, there is one field that is there, but its not linked to anything on the table. This is the description of a piece of equipment, only the Description...

Hi All, i think its going to be a For Each statement, but i could be wrong :) Im setting up a small database, its got 2 tables at the moment, table 1 is Customer Details. Holds Name, Address, Contact Details and the like. Table 2 is a "Sport" table, basically lists the type of sports that the...

Hi all I have a piece of VBA code, that sends out an email with a couple of links on it to files on our network. The email explains what the two files are and then has the two links. Above each link is a line saying something along the lines of: Please Click Below To View The Finance Report...