Search results

Hi, I'm trying to update a linked SQL Server table whenever data is appended to an Access table in a linked back end. I setup an after insert data macro over the table to call a saved query, but I couldn't get this to work. After researching online I found that others had achieved what I was...

Hi All, I'm trying to update a value in an SQL Server linked table on insert of a value into an Access table in my linked back end. I've setup an after insert macro on my Access back end table which calls a function to update the linked SQL Server table using DoCmd.RunSQL. This works...

Hi, Is it possible to move a record in a DAO recordset? I have some code that is looping through a recordset and allocating resource time to requirement. A late specification change has arisen and now on rare occasions there will be requirements that cannot be completed on the same day. I'm...

Hi, I've got an Access database system in place at the moment which has a lot of users, and which has a lot of automated procedures updating temporary tables with data from our SOP. It works well enough, but on occasion, probably about every 3-4 weeks, the back-end appears to corrupt. I get a...

Hi, Can anyone provide any tips for making conditional formatting a bit faster to load? I have a continuous subform with several objects subject to conditional formatting, including a long unbound textbox the length of the row. When I scroll in the subform I find that it takes a couple of...

Hi, I'm trying to do something which I have done many times in Access 2002, but I can't achieve in versions 2007 and 2010. I have a continuous subform with conditional formatting applied to every object, for the font colour to change depending on the value of one particular object. This...

Hi, This sounds really simple, and I'm sure I'm missing something. I can't find anything online about what I'm trying to do, maybe I'm not wording my searches very well. I've got a simple report with a detail section and two levels of grouping. In the top group I have column headings...

Hello, I'm modifying a report that retrieves data from a FoxPro-based system. One of the fields returned is a memo type field. Currently the report just returns the whole field, which could consist up to seven lines. Up until now this hasn't been an issue, but recently some records have been...

Hello, I'm trying to ensure that a particular workbook (named Despatch_Schedule) on a particular machine is closed at certain times of the day. The workbook is populated with data from an SOP, and needs to be closed while the update takes place. I have made a new workbook and given it a...

Hello all, I'm working on a project in VB6, but the code that I have issue with is basically the type of thing that I have recycled from old VBA projects, so I've posted it in this category. I'm populating a multi-dimensional array from a recordset, and it works absolutely fine with my test...

Hello all, I have a form which allows amendments of records. Before a combo-box on the form can have its contents changed, I am displaying a vbyes/no message box, which explains the consequences of a change and offers the facility to cancel the change. When the change is cancelled, I'd like the...

Hello, I'm trying to use some code in Access that was written for VB6. The code is in two parts, a class file and some code that creates a new object of the class at form level. When I've used it in VB6 I simply add a the class file to my project (control+D, and navigate to the file,) and then...

Hello all, I'm building a database that stores scheduled working hours for various groups of employees. The idea is that working hours for various shifts will be stored and then a query will output to Excel the scheduled hours for each employee from a user-selected shift. So for example, it may...

Hello all, I'm planning a database to allow the storage and retrieval of product information. Each product is to have an image associated with it, by saving the path to the image into a designated field. I would like to display these images in with the search results on screen, so that the...

Hello all, I'm trying to build a query that sounds simple in concept, but I'm having problems getting my head around it and would like some advice. I have a table that stores stock transactions and so has records that consist of a transaction date, the product's ID, the quantity and transaction...

Good morning all, I hope somebody can help me shed some light on the following: I have a macro that formats a populated Excel spreadsheet into a new documents and archives it on one of our servers. The formatting macro has been used on a small scale and is soon to be rolled out to a larger user...

Hello, I am working on the query behind a report that deals with durations and costs. At the moment the durations are in hours only. I'm using these durations in hours to calculate labour costs, based on hourly rates. But I'd also like the durations to be displayed in hours and minutes. So I...

Good afternoon, I'm looking for a way to reverse all of the values in a yes/no field in a table. That is that I wish for all 0s to become -1s and all -1s to become 0s. I've just checked the data and every record falls into one of those categories, none are null. I tried to build an update query...

Hello all, My apologies in advance for such a long post, but I really want to make clear exactly what my problem is, I'm sure that there is a relatively simply solution to this... We have an incredibly old SOP system which contains data regarding orders that are required for the running of our...

Hello, I'm trying to insert an image as an object in VBA. I have the following code: ActiveSheet.Pictures.Insert("C:\image.pcx").Select Which inserts the image as an image, but I would ideally like to insert the image as an object. I've tried replacing the word 'Pictures' with the word...