Search results

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?