Search results

I have a database that has been fully operational for over a decade. It ran without issue in 2007 but after changing to 2019 I'm getting a "There isn't enough memory to perform this operation..." error message. I'm a heavy macro user and there were two errors in syntax in the old version...

I am working remotely on a database. I've been able to open reports without issue and suddenly I'm getting the above message. I don't have access to printers and I can't even open the reports in design view. Can you provide some assistance please? As always, all help is greatly appreciated.

I've been working in Access 2007 forever and have a myriad of places where a form input is used as a query parameter. In the Criteria line I simply put [Forms]![FormName]![FieldName] and that's all that's ever been necessary. That has also been true of a temporary variable. I only had to put...

I'm creating a report that is really more or less a receipt. It has fields on it such as name, address, and the like, but it's not a report in the sense of printing a query or table contents. It would only contain data for the customer to whom it's being addressed. This page is essentially a...

I have a long established database and the users all log into their Access copy on their own C:\ drives. The company is moving and is going to a 100% remote access format. There will be no "office" per se, and the logins will be established through hosted servers on a private cloud. One of the...

To all you brainiacs out there this may not be a difficult thing to resolve, but it's got me pulling out what little hair I have left. Starting at the beginning, I have an Access 2007 DB front end running on SQL Server 2016 back end with about 20 users. Some have Win7 and others Win10 on...

I have a table that is constantly changing values. It's just a holding table for incoming things until they are dealt with, and then they are deleted, so there's only a few items in it at any given time. One of the fields is a unique value called WebID, and I would like to create a TempVar...

I created an internal Instant Messaging system through Access. The message form is a pop-up, but not Modal. The problem we're experiencing is that often the IM form opens while someone is in the middle of typing in a field on another form, and the characters being typed wind up in the IM field...

I have an Access2007/SQL Server 2012 system with 20 users for an insurance company. I've been accused before (fairly) of being wordy in my descriptions, but it's the only way I think those I'm asking for help can fully understand what I'm doing. The company does most of its business via a...

I have an Access 2007database, SQL Server , 20 users for an insurance company that has been established for more than 4 years and is working well. There was a serious error made when it was originally set up. Each insurance company was assigned its own field with its own name as a place to...

Which event precedes "another user has changed record" error in Access 2007? I have written a live queue for an insurance company. When a user inputs info on a web form it is immediately placed in a staging table in Access 2007 housed on SQL Server 2008. The count of unassigned records in...

I'm creating a report which is a legal receipt for shares in a company. In legalese, it's common practice to write the number of shares in words first, and then in numbers, like this: one thousand three hundred fifty (1,350). Is it possible to get Access to look at a number field and generate...

I'm writing a database for an insurance company that has as its core business model responding with a quote within 12 minutes. The company takes this very seriously, and wants an on-screen timer integrated into the form as the quote is being written. I already have an elapsed time timer...

I want to create dozens of reports simultaneously in Access 2007, one for each salesman, by setting the date parameters. So, for May 1-May 31, I enter the dates and Salesman1's report is created with only his data, and all other sales reps get their own indivudual report containing only their...

I'm doing something not generally associated with Access. I'm writing an analytical blackjack program. Anyone familiar with Access knows that it can be instructed to do the things involved, namely count the hand, stand or hit at a certain level, and anything else required to play the game. My...