Search results

Hi I am attempting to print a form which contains several subforms. The data in the subform header and detail sections displays fine. However the figures in the unbound textboxes located in the footer are not displaying - only blank boxes are visible. My print code is (although as a side...

Hi there, I am managing a MS Access DB coupled with SQL Server backend. Occasionally users report that records go missing and I it may have to do with the following error although I am not clear on what it means and what to do about it. If anyone can enlighten me I would appreciate!

I'm encountering an issue with Avast antivirus blocking a macro that's intended to automatically update Microsoft Access to the master version. Despite adjusting settings, I haven't been successful in resolving this problem. Below is the code to run: Option Compare Database ' global variable...

Hi I have the following crosstab query which summarises the sale figures for each day. However I would like to have 0s in place of blanks. When I try Nz() or IIF(null()) it doesn't work - probably because there are no rows to summarise for those days. Any ideas how I can do this?

Hi there Currently working on recreating a spreadsheet for a client in MS Access so the data displayed is dynamic. Their spreadsheet is like this: Based on a query I have created this: Not sure if this is possible but would I be able to hide the days where appears multiple times?

Hi there, I have a report which has a sub-report with a table layout. My issue is sometimes the Item row has more text than fits on the line so using the 'Can Grow' option it will wrap onto the next line. However: 1. the Cost column will remain aligned to the top of the row 2. the dividing...

I have this issue where I have scheduled via Windows Task Scheduler to run a MS Access file once a day which triggers a couple of emails. The database works fine when opened by a user HOWEVER when the triggered it will open a locked file and nothing else happens. Also it isn't possible to close...

Hi there, I have a report which has an image in the header. It will appear no problem in the layout and report view. But not in Print Preview or if output to PDF. Tried compressing image, resizing, convert to JPG etc. Nothing seems to help. This is on MS Access 2016 However it works okay on...

Another frustrating issue is I have several subforms which are datasheet view. I would like to expand the column widths but it will not save when I close and re-open. Any workarounds?

I'm looking to implement the functionality of the filter drop-down found in datasheet forms. Is there any option this can be done in a continuous form? Or somehow created? We would use a datasheet but we have some complex formatting requirements which are not possible in that design...

Hi, I have a database which calculates quotes for materials required based on the measurements entered (length and width). They now would like to include a table with what they currently have in stock. Then when entering the measurements it should check in the stock table if any length/width...

Hi I have a simple 'Find' option on a datasheet form. We would like to set by default 'current document' and 'any part of field'. Is this possible?

Hi I have a continuous form with alternate row colours (white and grey). I am looking to hide the text in one column when it has focus - usually I would change the text colour to white using conditional formatting. However it would not be transparent in the grey rows. Any ideas of how this...

I have a function in MS Access which exports a regular data query to an Excel format. The data mostly transfers fine, with the exception of a field with Hebrew alphabet which convert to unicode characters no matter what I try. Any ideas to get round this?

Please can someone help with the syntax to write a validation rule for a text field to allow no less than 6 characters of alphanumeric characters. Thanks

Hi I am attempting to set some objects in page footer to only appear on last page in report. So I tried to use methods shown here or here My issue is that the Pages property always returns 0 so it can't calculate last page in report. I am not sure if this is due to it being opened on a filter...

Hi there, A while ago I worked on an OMS system for a company. Every now and then they request maintenance. The system is based on SQL Server with Microsoft Access front end. Recently they complained of records going missing. When investigated it seems that these jobs are in the system for...

Hi Another query I am trying to build is to check if a wage has been calculated for each staff member within the last month and also to check if they have been employed over a month ago. How is the best way to build this?

Hi I'm sure there's a quick answer to this but cant find a suitable solution. I'm looking to automatically append records to a table which stores transactions - some staff have standing orders set up weekly. I would like this recorded in the database automatically. I have the weekly amount...

Hi, I'm back to work with my attendance database. The client requires more data manipulation and I'm really struggling to find the best way to achieve it. The requirements are: For each week (commencing sunday), find overall average of attendance for each student. Currently we have each...