Search results

Hi - long time since i posted & would appreciate a little advice prior to upgrading from Office 2010 to Microsoft 365. We have a database to manage our customers, quotes, orders etc which stores all the backend data in .mdb files on a raid NAS box. The front end is on 10 other computers in...

I have aquired some VBA that gives me the option to remove headers from a word document prior to printing. The is because sometimes i want to print to PDF using the header logo already in my document template, yet other times i want to print to our preprinted letterheaded paper. It works OK...

I have aquired some VBA that gives me the option to remove headers from a word document to enable printouts to be printed on letterheaded paper. It works OK but i would like it to remove footers as well as headers. Could anyone guide me in altering this code to suit. Many thanks Private...

Hi all, long time no post. Just tweaking a few things in a database and stumbled across an error. I've been using this code:- Dim mySTR As String mySTR = DLookup("MapLocation", "tblFileLocations") & Me.ContNo & ".axe" Application.FollowHyperlink mySTR, , True on a couple of...

Hello again AWF :o I have a problem i hope someone can help with. I have an access database that handles our customers, orders, quotes etc. and works quite well. It has become so relied upon in the office that others are now making suggestions they'd like to see on the development. Thats...

Guys i need help ! :mad: I have a real frustrating problem that i can't fathom. I have an database with a simple form with a listbox. I am trying to add an option group of 2 options that will change the rowsource of the listbox to look at 2 different queries. Seemed simple enough, but...

Hi all I'm after a bit of advise on creating an access database - i've been thinking of doing this for years but this year I WILL :o. I want to put all my names & addresses into a database & print the addresses out onto some sticky labels - it will saves hours in time not to mention the...

Hi all I am hoping someone can help with the attached sample database. I have created a query (qryHistoryPD) which pulls information from several other queries, some of which are union queries. In there it shows a date for "Last Calved" which is a date created from another query. I only...

I have a query that lists AI dates for animals. The same animal is often listed twice with different AI dates. I want to add a column to the query, where, for the most recent AI date for any duplicate animals it puts a date 280 days from that AID date ie My query returns:- DATE...

I have a problem that i don't know how to explain properly. I have a union query that pulls data from 8 other queries/tables to form a history of any given animal. I want to create a form with tick boxes to select which queries to include in the union query so that i can customise the output...

Hi all I am having trouble with some code for printing batch reports. I created a form with a load of tick boxes. There names are Report1, Report2 Report3 etc etc..... I have the following code to loop through which text boxes are ticked and to preview the necessary but one line is not doing...

I have a very strange problem that has appeared on 3 databases. Error 3027. Cannot update. Database or object is read-only. I have checked & changed nothing to do with folder persmissions etc. The 3 databases are independant but similar. All 3 use linked data tables. The error happens in...

Is it possible for a cell to have a formula to calculate a default value based on other cells but for a user to be able to change this value WITHOUT losing the cells formula. ?

Hi all I want to write a program. A quotation program. A quotation program that works out prices for buildings. Mainly steel framed & clad buildings. Its what we do. I am in a pickle as to whether an excel spreadsheet (maybe with some VBA backend) or an access database (will loads of VBA...

Ok i got a problem and i can't work it out - so i fall back to you guys again. I want to export some information from a query to a csv file. This is the code that creates my csv file succesfully. Dim AString As String AString = "Movements_" DoCmd.TransferText acExportDelim...

I am getting the above error trying to take an data from one listbox and copying it into a field in another listbox. The first listbox is bound to a table of addresses. The second is a listbox of quotes. In theory there should be a one-to-many relationship but this was originally 2 tables from...

OK i have a database that i have been developing as and when i have time over the years. It has become more and more complex and now 7 or 8 others use it in the office too. I am self taught and have been enjoying doing it this way. The db in question has become like a project management...

I have a report that prints address labels for contacts in a database. It works ok for printing individually but i want to 'batch print' some labels (xmas envelopes!). I have a form with a multi select listbox setup with the filtered contacts i want to print. I also have a button for 'Print...

I have just created a form with a subform. The subform is linked to the main form via a field 'TAG'. The main form has a listbox of cows available for being AI'd or Bulled. When a cow is selected in the listbox it brings up its own history in the subform. BUT..... The TAG field on the...

I have a strange problem. I am trying to add a new record to a subform but i keep getting the "Error 2105 - You can't go to the specified record". I have to main forms (frmFeedOrder and frmMineralOrder), each form has a subform & a products listbox. When a product is selected in the list box...