Search results

Hi, hoping someone has some bright ideas for this... I am wanting to put a notes section into a workbook, where notes can be added about a particular row in a worksheet. There will be lots of rows. I want these notes to be uneditable once they have been written, so they can't be tampered with...

Hi All, I have a requirement to copy some data from one sheet to another and then do some formatting etc. on it. At the moment the copy is manual from one sheet to another, but the formatting and sorting is scripted and working fine. What I would like to do, is the user to click a button...

Hi All, Today i have had a random error start popping up after a short while of having the app open and doing some development work. it will randomly pop an error box up say "Out of Memory", and i can't do anything else in Access, i have to close and re-open, but it always comes back up. Was...

I have a DB with a MySQL back end. Lots of people use this and it works brilliantly. Recently IT decided to change the server the back end is hosted on to another domain, so all the ODBC connectors on machines were updated to reflect this, it changed from a named server to an IP address...

Hi, I am having problems getting the below query to work in VBA. If I remove the "LIMIT 1" from the end it works, but how can i get it to work with the LIMIT 1 in place? Set rsCheck = db.OpenRecordset("SELECT * FROM processed_obox_Headers WHERE OboxID = " & OboxID & " AND TransmitTime BETWEEN...

Hi Guys, Hopefully someone can help with this, sure it's easy to resolve, just can't quote join the pieces up together. I have a report which will generate a pick list for the warehouse, can print a single version of it for a specific order absolutely fine. I have added a button to allow the...

I have a custom ribbon which loads and work perfectly. I now need to create some different views for different users with the app, each different type will need a different ribbon. I don't want to run 3 different version of the app, so want to load the specific ribbon when Access opens. I...

Hi, I have a cross tab which has dates as the columns, i want these formatted as mmm-yy as the day is unimportant, I can get them formatted as such, but when the sorting is applied they are sorted alphabetically not in date order. Is there a way round this? Having them show as dd-mm-yy will...

Hi Guys, I am hoping someone can give me some inspiration here. i am looking to create a form for project managers to enter a project budget into. This will be limited information, with financial inputs on the following: Income Materials Contractors Equipment Hire These categories could...

Hi, I am trying to create a query that shows data based on the selection of engineers selected in a multi select list box and date range. The query works fine with just the date range selected, but when I try and filter the engineers to those that i want i am having problems. I have a multi...

Hi, Quick question for opinions. I am looking at putting together a table to recording working patterns of employees, i.e. number of hours per day, and can't decide on the best structure to use: Option 1 ID | UserID | Day 1 | Day 2 | Day 3 | Day 4 | Day 5 | Day 6 | Day 7 Option 2 ID |...

Morning All, Hoping someone might be able to help on this. I have an app which uses the references for Excel, Word and Outlook to do various things. This has been running for the last couple of years, and i have never had problems with references, other than one for Mappoint, which isn't...

Hi All, I have created a cross tab to show the various stages of a project, and if they have been completed or not. The stages can vary from project to project, so can't use anything fixed. I have the cross tab showing the stages in the correct order, no problem. But what i am struggling with...

Hi I have the following setup to export some queries to Excel files. It on a loop and exports each one in turn. This has been working fine for month, then all of a sudden this morning it stops working, saying it's not a valid path, even though if I debug.print the path copy and paste it, the...

This is probably quite simple, but I can't get my head round it properly at the moment. I have a report which is used to create worksheets for engineers. The page header and footer are always the same on each report, and contain the generic information needed for a job. The detail section...

I have a report for stock allocated to engineers. There are several nested groups within the report for engineers, stock item, condition, type etc. I have no problems with the report, everything populates fine etc. but on thing that is annoying me is the alternative row colours. I would...

I need to create a database for a charity that I run. We have a version at the moment, but it is just a standalone with normal Access tables. What I need is a split database, with a MySQL or similar BE and multiple front ends I can distribute for other people to use. The problem is that...

Hoping someone can help here as this is driving me crazy now. Have the below code, top part which is commented out works absolutely fine, is just commented out so it doesn't run for the moment when I am testing the second part. Every time it runs, if I use .edit with the recordset I get an...

I'm not very strong with queries, but normally manage to find a way round the problem, but I have hit a brick wall with this one and need some help. I am making a system to tack site audits, each client can have multiple sites, and each site can have multiple audits assigned, and the tables...

I have a system that opens each morning, runs some checks and exports 3 queries to excel files. This all works nicely. I have tried to add some code to open each of these files, immediately after they are exported to apply some formatting to them, save, close then move onto the next export...