Search results
-
A
ComboBox to display all fields not only the link
Solved: ComboBox to display all fields not only the link Hi all, I have got a ComboBox which helps the user select a person they are looking for. When it is clicked it shows their FirstName, LastName and JobRole. However once they have made the selection it only shows the first value i.e... -
A
Dmax code issue - trying to find highest number and add 1
Hi all, I'm sure one of you guys can spot the problem here? I have been banging my head against a brick wall for 2 hours :( I am trying to find the highest Application_No and add 1 to it and then pass it to a text box. Easy right??? Private Sub Form_BeforeInsert(Cancel As Integer) 'curAppNo -... -
A
Free text box - Is there such a thing?
Hi all, I'm creating a small invoicing application for a friend. They are used to typing the invoice description (details of they are invoicing for) into a large excel box and free typing it. Is there a way I can emmulate this in access? I would need a textbox that stores character returns so... -
A
Increment field by 1 based on another field
Hi guys, a confusing thread title I know, I am struggling to define the question that is why I am struggling to find the answer. Here goes: I have got a table with the following composite primary key fields: Product_ID Product_Version I want the Product_Version to increment by 1 everytime I... -
A
Default control values - something or something else
I have got a form and depending on what form triggered it to open I want it to take on that primary key. In the default value of a control on the form that is opened at the moment I have got: =[Forms]![frmJobs]![JobNo] I need the same to happen but from a different form, so instead of... -
A
Best ways to store address history
Hi all, I have the following table in my database: INVOICE (InvoiceNo, ClientNo, InvoiceDate, CustOrderNo, CustRef) I obviously have an INVOICE_LINE table that goes with it. When I update the CLIENT table and then reproduce an Invoice it will take on the new address. I want to store the... -
A
Storing the company address
I have a database and recently the company have changed their telephone number. The address on all the printed reports was manually entered into a label. I am undertaking the task of changing this so that the address can be edited without me. Should I store this address information in a... -
A
Launching "Backup Database" from a button
Hi, I have created a database for a client that is maximised and has all menus hidden etc. I want to create a button that launches the Back up Database Office Icon > Manage > Back up Database Anyone have any idea how I could code a button on a form to launch that? Thanks- andy_25
- Thread
- Replies: 5
- Forum: Modules & VBA
-
A
Clear contents of a table on exit
Hi, I have a database and due to data protection reasons I need to clear the contents of a table when the database is closed down, is there a way of doing this? I have tried using me.undo in the form events etc to stop the data actually writting to the table however this causes problems so I... -
A
Problems calling a function from a command button
Hi, I am trying to call the following function in a code module from a command button on a form: Function PrintDoc() Dim WordObj As Object Set WordObj = CreateObject("Word.Application") WordObj.Documents.Open "C:\Project v0.1\PrintForm.docx" WordObj.PrintOut Background:=False...- andy_25
- Thread
- Replies: 18
- Forum: Modules & VBA
-
A
Getting over the page height limitation
Hi all, As you may or may not know Access has a page height limitation of 55.87cm. My report needs to be printed onto 4, possibly 5 pages with a different background image (pages of an application form). Without me having to split these reports up and having to fire 2-3 reports to print an... -
A
Link combobox and textbox
Hi, I have a simple database which has a combobox with the following query: SELECT PUPILS.[Pupil Name], PUPILS.Form FROM PUPILS; It's a simple query which has 2 fields. I need the user to be able to select a pupil from the combobox and display their form in a textbox. I have tried several... -
A
Link combo box and textbox
Hi, I have a simple database which has a combobox with the following query: SELECT PUPILS.[Pupil Name], PUPILS.Form FROM PUPILS; It's a simple query which has 2 fields. I need the user to be able to select a pupil from the combobox and display their form in a textbox. I have tried several... -
A
Where to start.....
Hi all, I have created many (10s) of databases for commercial use in the past and have taken on another project where I work now (a school). I am completely stumped as to where to start on this project and was hoping someone could help. The Project: Create a ICT Suite booking system for staff... -
A
Limiting Continuous Form Records
Hi all, I have a database with a continuous form based on a query. The problem I have is that the database includes images and therefore the continuous form is loading very slowly. What I would like to do is limit the view of results so that I only see 5 records at a time and have a button to... -
A
Question Ebmbedding JPEG images
Hi, I have a database which has 400-500 entries for a particular product I sell. I would like to add pictures of these products. I have added an OLE object field to my table for the purpose of storing an image of the product. I have 2 problems: 1. The only way I can seem to add an image is if... -
A
Date format problem
Hi, I am using someone elses code and I am struggling to get it to so what I want, could you help please. Const conJetDate = "\#mm\/dd\/yyyy\#" 'The format expected for dates in a JET query string. 'Date field example. Use the format string to add the # delimiters and get the right... -
A
setting default VAT (Sales Tax for non UK) value
Hi, I am creating an Invoicing database for a friend. In the Invoice table there is a field for VAT(%). When a new Invoice is entered I would like the form to show VAT at its current rate (15). I have created a table VAT_Rate with a field VAT. Is it possible to point the default value to...