Search results for query: *

Hello I have a table (Accounts) with the following fields DateDue RentAmount This stores rent charged each month. Every so often the rent will be changed (usuually increased). I need to look at the table and record each unique rent value and the date of its FIRST occurance. For example: I...

Hello, I have a form which shows repairs for properties. I currently open the form from a button and filter results to a particular property using the code below - which works fine. DoCmd.OpenForm "frm_Repair", WhereCondition:="[Prop_ID]= " & Me.Prop_ID The repairs also have a primary key...

Hello I have a Vba module which works fine for sending emails (through outlook). I have the option to attach 2 files in my form. Basically I have textboxs txtattach1 and txtattach2 which hold the file path for each attachment. If both attachements contain a file path then it works no...

Hello, I have added to the end of this concatenation, but can not get it working. I think I have an error after the last AND statement - can anyone help? Thank you Mark Me.Filter = "[Inv_Invoice_Dated] BETWEEN #" & DatStart & "# AND #" & DatEnd & "# AND [Number_Value]<> true AND...

Hello I am trying to make a filter that filters the current form on click of a button. I need it to filter the form by the following criteria LL_Select - is an autonumber which is selected by cbo_LL_Select DateStart - is the start date which is held in textbox txt_DateStart DateEnd - is the...

Hello, I need to remove everything from the last comma of a string (including the last comma) So for example I have an address 20 Bright Street, Walsham, England, CH41 0AD And I need: 20 Bright Street, Walsham, England If anyone is able to help me with this it would be great. AND If...

Hello, I use a database to launch other applications and databases. I call this 'Launcher' The Launcher app has a small window size. When I launch a new database, it then opens in a small application window. It uses the following code: Public Sub fnc_FS_OpenApp(ByRef strDocPath As String)...

Hello, I want to make my database appear floating and compact. I use the following code to prevent the user from using the Maximize Access Application button. Option Compare Database Private Const GWL_STYLE = (-16) Private Const WS_MAXIMIZEBOX = &H10000 Private Declare Function...

As title, we run a small company on Office 2013 (Access, Outlook and Word mainly) As support has gone, I would apprciate thoughts on whether to upgrade to 2019, 2021 or wait for the next release? We do not want office 365 at this point. Many thanks Mark

Hello, I have a form which has several textboxee which are set by user interaction. When adding the record some of these text boxes will hold numeric keys for linking to other tables. The fields in the table receiving these values is set to integer. I notice that is no value is held in...

Hello, I have a fairly urgenet need to work out how to connect to an extrenal access database and take all records from a named table and paste them into a table of identical structure in my local database. I have tried transfering the table, but ran into problems with the imported table being...

Hello, I have added up all payments in a table and get a sum that end in 3 decimals. Obviously there must be a typo in there somewhere. Initially I have formatted the currency field in the table to show 3 decimal places. My intention then was to use the Right function to select the 3rd...

Hello, I have an address text field that is formatted like: 7 Haven Street - (Smith), Liverpool, England I need a public function that i can use in a query to return the result as follows: 7 Haven Street, Liverpool, England Basically I need to remove the -, the text inside brackets and...

Hello, I wonder if someone can help me with an append query. I need to append bank numbers and telephone numbers to a table. When I run the append query from design view, the zeros are displayed. The destination table has the fields set as 'Short Text', but when the append query is run, the...

Hello, I have a very simple database which only has one form. I would like the form to look like it just opens on its own and without showing any of the Access Application. Is this possible in Access? Thank you Mark

Hello I am trying to filter a subform from another subform using the on current event. Forms![frm_Contractor_Job]![Subfrm_Contractor_Job_Detail].Form.Filter = "Inv_Pman_Prop_ID_WorkAt_Link =" & Me.Repair_Property_ID_Link And "Inv_Pman_Cont_ID_Link =" & Me.Repair_Contractor_ID_Link I think...

Hello I have a form with web control (Access 2013) I have a list of files which using the on current event previews the current recorsd file in the browser control. It all works great - but I have an annoyance. When the file type is pdf, jpg etc all is fine and it displays fine. But if the...

Hello I need help in how to add multiple contacts to outlook (contacts are in an access table tblContact) I have code for enetering one, but can not seem to get it to work with record set and loop. Could someone help create a function to add all records from tblContacts. Thank you Sub...

Hello, I would like Outlook to filter my email so when I get an email from one of my contacts it puts it in a seperate folder. I understand how to do this using rules. I would however like to be able to update my contacts from my access database. My initial idea was to create a linked table...

Hello, I have a field in a database called [ADDRESS-SINGLE-LINE] So for example the single field would contain: Flat 10, 24 Church Street, Boonbell, London, L4 5RT I need to convert it to a multi line address which I could store in a single field [ADDRESS-MULTI-LINE}or perhaps generate it on...