Secure authentication to Azure SQL Database

Best Microsoft Access Programmer Portland OR

Hi, all.

The company I work for has an old Access database that I’d like to move the back end to Azure SQL Server.

I think the best way to do this is to migrate all the data to the new Azure db, and then link the tables in the back end file to their azure counterparts (although, if anyone has any suggestions otherwise, they’re welcome!). I have already migrated all of the data to the new azure db.

Setup details:

  • The Access db
Read More

Form to browse long text fields with short text index.

Best Microsoft Access Programmer Portland OR

I have a table like this: NoteDateTime DateTime Description ShortText Narrative Long Text

I’m trying to create a form so that on the left side of the screen there is a list containing the short text and description of all the rows. When I click on a row, the right side of the screen populates the narrative.

How can I go about this? Thanks!

submitted by /u/DevilDoc44
[link] [comments]

Microsoft Acess Developer Portland ORRead More

Drop-Down field with additional options — is this possible?

Best Microsoft Access Programmer Portland OR

Hello all! First of all, I’m new to Access and programming. I’ve made a few databases before, but nothing too complicated.

Right now, I’m trying to do something, but I’m not even sure it’s possible.

The database tracks products and vendors. In the form to edit a product, I have a drop-down field where I can select all of the vendors that sell that particular product. However, I would also like a way to indicate whether the vendor is Preferred or Optional.

For example,

Read More

How to inherit attribute data from another table

Best Microsoft Access Programmer Portland OR

I have two tables, for example: Flights and Members. Flights store’s information such as flight_number, depart_time, arrive_time, etc. Member also has a flight number attribute.

I want it that when I select a certain flight number on a form when adding a new member, it automatically fills in the arrival and departure time as what the flight number’s arrival and departure times are. This is basically to make the data-inputter’s job simpler so they don’t need to keep copying the same info for the

Read More

Access Form Control Arrays and Event-3

Best Microsoft Access Programmer Portland OR

Access Form Control Arrays and Event-3

This is the continuation of last Week’s Topic on Text Box AfterUpdate and LostFocus Event capturing and performing Validation Checks on values, in Class Module Array.

Last week we have stopped short of discussing how to move all the VBA Code from the Form_Load() Event Procedure into another Class Module and leave the Form Module almost empty of all Event Procedures.  The VBA Code that defines the Text Box Control Class Module Array and invoking the required built-in Events in their respective Array elements.  … Read More

Creating a search field in a form that updates a list

Best Microsoft Access Programmer Portland OR

Creating a search field in a form that updates a list

I tried following this tutorial to create a textbox search field in my form:

https://support.office.com/en-ie/article/create-a-text-box-on-a-form-that-looks-up-a-value-in-a-table-7ec1b587-d158-4ae3-9d97-80e8119cff7d

But I came out with a few problems and I still don’t understand how I can make it update a list of entries.

I have a database with people, and I’m trying to search by attribute name. The table is called People, and I would like to search for a name and have a list of matches appear below, similar to the image:

https://i.redd.it/pxyke4rflly21.png

Once

Read More

Help – Trying to sync combo boxes on a form

Best Microsoft Access Programmer Portland OR

I have been charged with creating an access db for recording Quality Assurance of my staff in an office.

I have run into an issue that i cannot overcome, no, matter how many tutorials i look at

on the form, i use a combobox Called USER to select the name of the individual that is being QA. this data is stored in a table is called USERs and has the following Columns

NCCAD TEAMLEADER
Bob Mr Jones
John Mr Smith
Gary Mr Smith
Read More

Cannot figure out cause for Error: Not a valid bookmark! (Tried Rebuilding and Compact+Repair)

Best Microsoft Access Programmer Portland OR

I am having issues with my BackEnd. While staff are using the database, they will get an error: “Not a valid bookmark.” I am unable to determine the cause and I have tried to rebuild the database by importing all objects into a new database and I’ve also tried Compacting & Repairing.

The Set-Up:

  1. BackEnd (Has tables that stores Daily Stats, Combo Box Values, Versions/File Paths, and a KickOut feature)
  2. OTC (FrontEnd menu with buttons linking to the Narrator or ONE&Done)
  3. Narrator (Does not
Read More

Help with Top Function

Best Microsoft Access Programmer Portland OR

Hello,

I am trying to return a Top 3 grouped by other criteria such as salesman. If found this SQL solution, but it does not seem to work.

I’ve been working with a part-time Access programmer at my company and he is stumped right now as well. We thought we had it working last week, but must have been getting a false positive.

SQL and Results: https://imgur.com/a/zcNCubv

Any help greatly appreciated!

submitted by /u/uss_asser_prize
[link] [comments]

Microsoft Acess Developer Portland ORRead More

Page 809 of 814
1 807 808 809 810 811 814