Search results for query: *

I'm fooling with a game program idea in Access that requires rolling of dice 1000x and summing the two of them, roughly equivalent to 1000 rolls on a craps table. I used the Rnd function successfully, but it doesn't run hands sequentially to store them in a table for future reference. I'm...

We have a long-established A16, SQL Server 2016 DB for an insurance company with about 20 users. I've been asked to investigate whether Access has texting capabilities. It's an easy matter for me to create the list of clients to whom we would like to send a text message. I'm trying to find...

Really, the subject is the whole question. I have text fields on a report (General Number format), and if possible I'd like to display a + before positive numbers. Any suggestion is appreciated.

I have a longtime DB in A19 and SQLServer 19 with 20+ users. We have a table listing our representatives appropriately called Reps. They are not the actual sales people, but their names appear on each sales record because they get credit for them. El Jefe commissioned me to create a new...

This DB has been up and running since 2010. I have relied fairly heavily on macros in its development. I know that the coders see them as being somehow an inferior way of getting the job done, and maybe they are, but they are also a valid part of the toolbox that Microsoft designed and...

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'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 have mentioned several times in the past my 20+ user system for an insurance company running access 2013 and SQL Server Xpress 2018. The individual insurance companies with whom we do business send us a list of canceled policies in a PDF format. Our personnel have to manually go through that...

I have a 20+ user Access DB with SQL Server 2016 back end for use in a large insurance agency. We have what we call ShortApps, which are Word documents created with Mail Merge to be populated with info from the Access customer record and which are ultimately attached to an email and sent to the...

I have been asked to create a routine to divide a list of customers among several employees for them to be followed up. For simplicity, imagine a list of 100 records to be split among 10 people. My thought was that if I could run a query that would assign the numbers 1-10 to each record in the...

I have a table that is used to calculate monthly commissions. Once the month is over and data has been saved there's no need for any of the info in the table, so it is deleted entirely awaiting the start of the following month. It couldn't be simpler. All data is removed and it's usually not...

I'm currently running 2007 version and would like the capability of sending text/SMS messages to people in my database. Do any of the wizards out there know an effective means to accomplish this? As always, thanks in advance.

I am running the following code. Private Sub LeadSource_DblClick(Cancel As Integer) DoCmd.SetWarnings False DoCmd.RunSQL "UPDATE CustomerInfo SET CustomerInfo.Cell = [Enter Cell Number Digits Only Here] WHERE (((CustomerInfo.ID)=[Screen].[ActiveForm]![ID]));" DoCmd.SetWarnings True End Sub I...

This is probably easy for the wizards out there, but I'd like to have a value in a text box that says something like "Insert Name Here", preferably in grey, which wouldn't save the words "Insert Name Here" to the underlying table. It's like an information reminder for the user if the field is...

I work for an insurance company and they are changing their commission payment structure. I was given a .pdf grid that contained the values they want to use to determine commission rates. I recreated the .pdf in a table and have included an image of both the .pdf and the table side by side for...

I'm in a multi-user environment, split db, running 2007 and 2013 versions. I want to limit the access of some users to see forms only, while others will have access to all objects. I've looked at just turning off Navigation Pane but I'd prefer to have it display forms only. Opening Access...

I HATE it when something that should be easy turns into a can of worms! I have two tables, AllVehicles and Dealers. Both have a common field, DealerID, which is the PK of Dealers table and just a simple data field on AllVehicles. I have a field in the Dealers table, 1stQuote, which is...

I'm using Application.FollowHyperlink to open incoming faxes that are in .pdf format. Of course, they open in the default program for that filetype, which is what I want. I really can't do it any other way because different computers have Adobe Reader in different places, and some even have...

I ran across this link. https://www.fmsinc.com/microsoftaccess/SQLServerUpsizing/how/index.htm In it they explain four different usage modes for Access. 1) Microsoft Access and Jet Single User 2) Microsoft Access and Jet Multi-User 3) Microsoft Access, Jet, and SQL Server 4) Microsoft...

I have several places I'd like to use this, but here's one example. I have a processor name form that lists employees who are processors. Within that group are several levels that are denoted by checkboxes and later programming that allows them to do (or not do) certain things. On the form...