Search results

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 Best method which worked for me was having textbox 'page n of m' in page footer. Then use following VBA for logic: Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As Integer) If Page = Pages Then Me.Image53.Visible = True Else Me.Image53.Visible = False End If End...

Thank you. I will try that I'm not concerned about the speed as these reports will only be couple pages at most (or just one page usually).

No. I've just been using Me.pages in vba for the logic

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...

Thanks again for the tips above. It was pretty straightforward to iterate through each staff member and compare the dates of start and last paid - using your sample queries above! And of course half the solution is knowing the question - which is why I find it so useful to air my questions on...

Hi and apologies for the week late response. I did intend to respond in detail as soon as I resolved the issue. So I wrote a simple script to iterate through the active staff and append to the transaction table so long as it was over a week since the last transaction (of that type) was...

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...

Its more data than you think but I will try! There are two connected tables with attendance data - sessionLog and studentAttendance. There is a simple query joining and filtering the data. Here is some sample data: qryAllStudentAttendanceDates fldStudentID fldDate fldAttended...

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...

Yes I have tried that. My latest discovery is it works when form is NOT pop out but when i select pop out the 'totals' are greyed out. But now it works because I already set the totals when form was not pop out. Weird work around!

Hi @CupKat - you are in the right place! Wish you much success on your project

Hi there I have encountered an issue which seems to be quite common but can't find a resolution. I have a subform which is a datasheet. The recordsource is a query. I am trying to add a totals row - it works as a query but will not display in the form. Any ideas why? This is the base query...

Thank you for these valued pieces of advice. Definitely some leads to look into. Will post further queries when I have done more research.

Hi I work on a team of software developers who specialise in MS Access database development with use of SQL Server. We have noticed that it seems to be the expectation of current clients to have a fully hybrid solution which can be accessed on mobile/web apps seamlessly. We are looking for a...

I understand your point re exporting from QuickBooks. Hopefully there will only be minimum overlap between my solution and their systems in place already as I am not trying to replicate what they have in place. So only relevant data will be necessary to be be exported.

You are 100% right that the import process should prevent duplicates being imported. Usually I would use an ID to check what has been imported previously and compare data. Since I am only at the stage of understanding the data design I did not involve these data points. I will have to look in...