Search results

I have created an app that is used by me, and two other users. I have split it into 2 files : tables in one file and everything else in the other. I need to put the tables.accdb file on a network drive and link to it, but we do not have a network. Are there any cloud solutions that provide...

I have converted an desktop Access database to SQL server. A medium sized app with 24 tables, 60 or so forms/subforms and about 120 queries. I created 2 split files, one containing the tables, and the other containing forms, queries, vba modules. I migrated the tables to SQL server using SSMA...

I'm using Access 2013/64bit. My form needs a control which is a select file dialog. Where do i find this control? I've googled and the results were vague at best. I'm guessing its an active x control and i have to reference it in. That's all i know, help pls I need it cos the user has to...

I don't do light topics, so apologies in advance lol... I used to be afraid, of death, really afraid. The thought of it would practically give me panic attacks. Most people are scared of death to some extent, but my fear was extreme. But then, about a year or so ago, something occured to...

Adding "All" selection to a combo box that acts as a filter for an SQL statement My form has a combo box which is bound to a query that selects a list of member numbers. The value selected the goes onto filter a list driven by an SQL statement. Private Function PopulateADO(qpMemberNo As Long)...

I have a MEMBERSHIP MASTER form which carries membership data, and this form has a subform called MEMBERSHIP SUBS which shows all the annual subscriptions the member has had over the years this is the linking : Parent Form MEMBERSHIP MASTER MemberNo...

Hello folks I'm trying to populate a list which is an Access form that is Default View: Continuous forms. How do you get to bind to a continuous form's fields with VBA and DAO? I guessed that the form object was an array Here is my code: Private Sub PopulateForm() Dim njpn As DAO.Database...

My table key looks like this. Its a table that keeps a master record of conferences that occur during a calendar year ConfYear (Date/Time) primary key ConfNo (Byte) primary key As you see its a composite key. Now each time a new record is created i want the ConfNo to...

A Christian Charity based in UK needs a volunteer Access specialist of intermediate to advanced level, with good Access, VBA and database design and data migration skills. This is to take over the volunteer job i have been doing for the past six months. No pay but a huge opportunity to develop...

Been developing this admin system for a charity. I've got the forms and queries in one .accdb file and my tables in a separate .accdb file. The forms file links to the tables in the tables file. The tables file resides in a folder called simply enough C:\acc_tables and thats where i browsed to...

I got this function which is supposed to find a record based on the primary key, and then give three fields a value if they should be empty. --------------------- Public Function DoesXrefExist(faPersonID As Long, faRoleCode As String, faDorpID As Long, faDorpCode As String) If...

Connecting to external data sources is a new thing i'm learning so bear with me pls. MYSQL is a natural choice for me over SQL Server as i have been using it a lot with php and i'm used to MYSQL workbench and phpmyadmin etc etc.. I loved the way that php had native support for mysql rather...

Hello All, I've got a string variable with a value that could be typically "ABCD|123|R" The string needs to be split into its three parts, the pipe symbol being the separator. Then the middle numeric string must be converted back to a long Forgetting the string to long conversion for moment...

I've got a tabular form called PEOPLE LIST which is data sourced by a query. Records in this form get updated elsewhere and i had a piece of code embedded in the updating form which went: [Forms]![PEOPLE LIST].Requery All went well and life was happy. The changes made were reflected in the...

On my app I have an Options form with an option group that says 'Docked' or 'Moveable'. This is so my users can control the look of certain forms. The value of the option group is Docked =1, Moveable = 2. This value is then passed to a global variable . ******************************** Private...

I have created a medium sized Access app, and I want the database on a server for the advantages that gives, and retain the Access front end. For me MYSQL is the natural choice as i have used it before. SQL server i don't really know. I have MYSQL server/Phpmyadmin and the Mysql odbc drivers at...

I'm getting sick of Access 2013 constantly doing this. I convert a macro to VBA form the ribbon menu then it doesn't run! I've uploaded a screenshot of the latest error to irk me. This ran perfectly well as a macro but sice i converted it to vba. (cos somethings i can do easier in vba than in...

I've got this table that had email address and website fields as short text types. I have created two new hyperlink type fields and cut/pasted all the data from the old fields into the new hyperlink types. They show up fine in the form and the cursor changes from an arrow to a hand when hovered...

In my form my combo box displays a list from a query called DORP-HDR that has 3 columns DORP-ID | CODE | NAME and displays them like that is the drop down list The form field that the combo is bound to takes the numeric-id field as its value. In the combo control wizard i nominated that value...

I'm inserting a new field into a large table and the value of that field is going to be either TRUE or FALSE depending on a value of an adjacent field that already exists... The new field defaults to FALSE but there are several hundred records where it needs to TRUE. Can i get SQL to handle...