Recent content by REZ

Thank you. I'll give it a try

Do you have a code I could use to do it without a DSN?

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 want the blank subform there when the form first opens. that line is on the form load event.

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 just got it sorted. Asking the question helped me think through exactly what I had changed. I had changed it to an unbound report, with the month name and year being populated with the report On Load event, instead of filtering the underlying query with the month and year I needed as in the...

I'm working on a school database, the report is a month calendar view of a students register records. When a button is clicked on the students main profile page the report pops up that month, with every day of the month linking to a subform with the detailed info for the day. The Student ID...

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?

Can you tell me more about your company? What exactly does it offer? do you have a website I can get more info?

Thank you. I tried doing some online research a while ago, but got very confused. I'll have a look at the link you sent me

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

That is essentially what I tried to do with a Union query. Thanks for your help. I'll try do it as a table instead.

How would I set this up so the user inputting the expense can just put it in once without seeing the joining table?

Thanks all. I've been away from my desk for a few days. Just read through your suggestions A joining table won't work, some expenses cannot be split (e.g. a gardening expense for an entire complex) I think I'll keep my form for general viewing, using the union query in the underlying control...