Search results

I've created a small database for a small organisation. They don't have a server, only the boss uses the database. Some reports need to be filled in by other, so I created a button to export to excel, and then import it back. Now they are requesting that there be combo boxes on the excel...

I'm trying to export an MS Form, and then edit it. My code works fine the first time, but when I try it again I get errors. It think its because the Excel application is not closing properly. I've searched all over to try get it to close, but its still always there in my task manager...

I have a split MS access database, I'd like to convert the backend to a SQL server on my server, and link it to frontends on other computers on the network. I think i understand the process of exporting the tables from the MS backend to the SQL server, and I've managed to a frontend to the sQL...

I've got a multi user, frontend/backend database. I can see someone has left theirs open as their is a record locking file. Can I determine from the backend which computer has it open? or can I force close all frontends?

I have this code for a form on click event Me.ViewingForm.SourceObject = "report.rptBalanceSheet" Me.ViewingForm.Report.Filter = "id = '" & Me.CmblandlordsACC & "'" Me.ViewingForm.Report.FilterOn = True Where "viewingform" is the name of the subform control The code runs fine, but after...

I have a report with several subreports Everything works fine in report view, but they all disappear in print preview. It has printed fine in the past, but I changed some textboxes to get info from another form and now its not working anymore. What am I doing wrong?

Hi, I need to migrate my backends to a cloud Sql Server to allow users to work from home. I've been working on Access for quite a few years, but I'm completely lost with Sql servers. Can anyone give me step by step instructions? Thank you

I've got a form Frmexpenses based on Tblexpenses. Each record can be allocated to a property, a property group or a landlord. there's a qryPropUnion which puts together all of them, and on the Frmexpenses I've based a combobox CmbProp on this Union query. The second column in the union query...

Hi, I'm trying to change the color of a textbox on a continous form. I need to color to change based on the RGB values in the text box. Is it possbile to do?