Search results

If I try me.txt_so_promised_date = Me.promised_date The problem is that when promised_date is Null I get a generic error. I was trying to trap for Nulls to prevent this error which led me here in the first place. When me.promised_date has a date everything works fine. I'm not even doing...

Yeah sorry I realised my logic was flawed and have since corrected the original code but it makes no difference. Should have been If Not IsNull. Me.txt_so_promised_date isn't bound.

If me.promised_date Is Null Then Gives me an Object Required error. If nz(me.promised_date,0)=0 then Gives me the same original error. What's weird is if you look at the image below, I have simplifed the query by just using SELECT *, and stepping through my code, the yellow highlight is where...

I ommited most of the code because it's very specific to my form/query but see below: Private Sub main_form_requery() str_sales_order_item_qry = " AND sales_order_status.Sales_Order_Detail_ID = " & Me.cbo_sales_order_item_id_filter Dim str_main_form_qry As String str_main_form_qry = "SELECT...

I have a form whose recordsource is updated on the AfterUpdate event of a control on the form. A query is built according to the value chosen in the form and the form's recordsource requeried accordingly. One of the fields returned by the query is a date field (promised_date). A bound control...

That was my initial suspicion but in between this happening the last time and recurring today we've gone about 4 weeks with 5-10 people using it simultaenously daily for about 4 weeks.

The forms/reports are definitely getting deleted as they're no longer in the forms/reports list when I try to view them. But another user connected to the same front-end can still see them. The error message is a generic Access message - see image below. main_menu_login is our main menu form...

Each user logs into their own instance of a virtual machine/remote connection and opens the same front-end. This issue can affect one user but not another. I say locked stated because if they actually tried to edit or delete a form manually they would recieve an error saying they don't have...

Nobody is editing any forms or reports, they just enter data. Only I do any form of editing. The database is split as I mentioned above, MDB Front-end connected to MySQL back-end. Forms are just randomly disappearing mid session. The users open the database in a locked state so couldn't even...

We have an Access database we have been using fine for years without any issues. The database is an MDB front-end connected to a MySQL database backend. We recently moved to Office 365 with the database running on an Azure server and users connecting in using Microsoft Remote Desktop. Quite...

There will be 10-15 users tops and they're using RDP through Microsoft's own Remote Desktop App.

I'm working on the assumption this will only ever be accessed by a Windows device with a desktop.

Hey guys. Our Access DB has a button that allows users to save a PDF of the report they're working on, to their desktop. We are moving our Access Database online to be run from an Azure Virtual Machine, but this button now saves the report to the VM's desktop instead of the local desktop...

Following on from this, can anyone recommend a technology for quickly building web forms and reports? I'm already proficient in PHP and MySql and can hand-code forms no problem. But I have about 100+ to build and doing it manually will take me a long, long time. I wondered if there was a...

We use an internally-developed database system that utilises a MySQL back-end running from a server running XAMPP, connected to a Microsoft Access front-end using ODBC that runs locally from every user's computer. We are looking to move away from the typical Microsoft Server 2012 Active...