Modules & VBA :: Using Unbound Form On Front End Of Database To Populate Backend Tables

Apr 12, 2015

Is there any particular reason I would choose to use

DoCmd.RunSQL "insert into...

Versus

CurrentDb.Execute "insert into.... ??

I am using an unbound form on the front end of my database to populate the backend tables (multiple tables). Some forms only have a few fields, while other forms have about 15 fields with 3-4 tables updating.

I am okay using the DoCmn.RunSQL , but I keeping reading on the forum that others chose CurrentDB.Execute and it has me thinking.

My database is stored on a network drive with only on front end.

View Replies


ADVERTISEMENT

Backend Database - Front End Application Linking Issue

Nov 25, 2007

Hello all,

I have a back end database that i cannot access at the moment. Is it possible to set the link of the tables for the front end application based on the location that the database will be even though i can't see that location now?

Thank you in advance.

View 1 Replies View Related

General :: Split Database - Modify Backend File And Make A New Front End

Jun 12, 2012

So a while back I created a database which I use to keep track of my companies large list of products. It is very simple only 3 tables, 1 query and 1 form. After running into a problem with copying and pasting updates on each computer in the office I decided to split the database on a network drive. This worked for a bit, however I had to add new fields and modify the form, which corrupted the file. Luckily I had a backup before the split.

As far as I could tell all I had to do was modify the backend file and make a new front end. However it seems like it is not as easy as I thought it would be. How do you modify a split database without corrupting the files or using a non-split copy?

View 1 Replies View Related

Modules & VBA :: Update Open Form After Linking To A New Backend Database

Mar 18, 2014

I have an Access DB with a form that allows the user to select a new backend database. I can connect to the backend and then .refreshlinks but nothing on the form is updated. I have tried requiring the form but that doesn't do anything. I've tried loads of other things, refresh, recalc etc., but nothing updates the open form.

The only way I have managed to get it to work is to close the form and reopen it, then it shows the data from the newly linked backend database.

While it works, it doesn't look good but also there seems to be some problem with it because eventually it reports an error saying "cannot open any more databases" and when clicking OK comes back with "An error occurred while sending data to the OLE server (the application used to create the object" and a whole bunch of other messages.

I think it might have something to do with the fact that the form has a number of MS graphs open on it, but I'm not sure. Also, I can't track down a particular line of VBA code which causes this error.

how to update a form after changing the backend database.

View 14 Replies View Related

Forms :: Unbound Combo Box Populate Fields Linked Tables

Jul 18, 2014

I have form with an unbound combo box which is populated from a query

It should populate a field in a table which is related to another - however it only works when i query by id number (primary key) and not the text value i want - is it possible to query both so it returns say 1,option 1 - then when selected it will place a 1 in the table - which is related to option 1 in another table instead of just having to select '1' which will mean nothing to a user?

View 5 Replies View Related

Tables :: Splitting Database - Front End Does Not Link To All Tables In Back End

May 28, 2013

I am splitting a database and have created the Back end already. When I create the front end and link to the tables on the back end... The front end does not link to all the tables in the back end. The list that comes up when creating the linkings does not show all the tables in the back end. What would cause this?

View 1 Replies View Related

Access As Backend And Swishmax As Front End

Oct 7, 2005

HI:
anyone got any suggestions about using access 2003 tables as the backend and swishmax as the frontend. Thanks in advance.

View 2 Replies View Related

Sybase Backend Access Front End

Jan 12, 2006

Is it possible to do this?

if so what kind of connections would i use?

and how would i connect?

View 2 Replies View Related

Sybase Backend Access Front End

Jan 12, 2006

Is it possible to do this?

if so what kind of connections would i use?

and how would i connect?

View 1 Replies View Related

General :: Many Front Ends And Only One Backend

May 7, 2013

I have (on a company network) a FrontEnd .accde and a backend .accdb - currently ~ 10 users (some over wifi - slow!)The FrontEnd is becoming a rather large file ~ 10 MB and is also becoming slower.I am looking to separate this in to 3 FrontEnd files as to simplify and to lessen the file sizes etc.

My question is - are there any issues around a 3 x FrontEnd databases all connecting to 1 x backend database holding all the tables - over a network?

View 11 Replies View Related

Can You Populate A Unbound Continious Form

Feb 18, 2005

Can you populate a unbound continuous form. If yes how do I do it

Phil.t

View 8 Replies View Related

Unbound - Populate Textbox In Form

Nov 13, 2012

I'm trying to populate a form textbox which is unbound.

I have table with a list of peoples login names and a query filtering these names once a user logs in. If the GetUserName() matches one of the names in the table then user is authorised. this part seems to be working fine. User not on the GetUserName() list the filter says blank ie Not Authorized.

How to take this confirmed user name and place it into a textbox on a form?

Table name: [tblUserNames] with [IngEmpID] & [UserName]

Query Name: [qryUserNames] with a Criteria GetUserName()

View 7 Replies View Related

General :: Transfer Tables Directly To Backend Database?

Mar 12, 2013

I'd like to to import some large oracle tables from a remote server using "DoCmd.TransferDatabase..." on a daily basis. Currently, the system works, but my database is getting quite large (800 Mb) and I'd like to split off the tables to a back end database.

Is there a way to import directly to the back end database? The postings that I've seen seem to imply that one must first import the tables into my front end, then export them into the back end. Does that sound correct?

I'm at home right now, but will give it a try when I get to work. It just seems like there's got to be a more direct way!

Jon Mulder
Department of Water Resources
Red Bluff, CA

View 4 Replies View Related

Modules & VBA :: Force Disconnect From A Backend Database

Nov 17, 2014

I have a database stored out on a shared drive at my company that multiple users connect to via a front end application that they save on their own hard drives. Recently I have noticed that the back end database keeps getting opened exclusively which prevents other users from being able to access the back-end database. For the life of me I cannot figure out what about the front end opens the back end exclusively and cannot find any plausible solutions I thought I could develop something that could force close a back-end database or disconnect all users from it?

View 3 Replies View Related

Populate Unbound Fields On A Continuous Form

Oct 5, 2004

Can I populate unbound fields on a continious form, if it is possible would you give me some code to look at or direct me to an article

Phil

View 2 Replies View Related

Forms :: How To Populate Unbound Continuous Form

Dec 19, 2014

I found a few regarding continuous form data but its not the sample that fits.

Attached here is my screen shot and my accdb file (MSAccess 2013)

How do they populate unbound continuous form from msaccess connecting to mysql server.

It should display 5 data but in my case it does show only one data.

View 8 Replies View Related

Modules & VBA :: Split Database - Moving Table To Existing Backend

Apr 8, 2015

I have a client that is using a split database. I am working on an update to the program and need to transfer a table to the backend that has the correct structure and information included in it. My thoughts are to make a one time use program that transfers the table to the backend. I have seen DoCmd.TransferDatabase and DoCmd.CopyObject as possible ways to go.

View 10 Replies View Related

Modules & VBA :: Replace Front End DB With Another Database

Sep 23, 2014

I have a split database. When the front end db is updated, i am attempting to delete the end users copy and replace with the updated version.

I have gotten as far as being able to open Database A, Open Database B with A and Close Database A, but it will not let me delete Database A from B because the procedure originated from Database A.

View 11 Replies View Related

General :: Use Unbound Controls On Form And Populate With Pure VBA Recordsets

May 16, 2013


What really is the best way, programming-wise and user experience-wise when presenting records in a form:

1) Use the form with sub-forms to show records. Add new records via a popup form and use recordsets in VBA to allow validating.

2) Use unbound controls on a form and populate with pure VBA recordsets. For data with more than one row use list boxes. A popup form used for adding new or editing etc using VBA.

3) Another I haven't thought of; new or a combination of above?

View 2 Replies View Related

How To Make Unbound Field Auto-populate Conditionally From Another Unbound Field

Jan 30, 2015

To make it simple, I have a list of contact names and their email. I want to have a form with no control source and have 2 simple drop down boxes for their Name and their Email. What I would like to happen is the user choose a name from the drop down in field 1 and then the field below auto-populate their email in field 2. I understand I can use conditional IF/THEN and list out each email, but the contact list is ever changing, so I want to first drop down to link to the TblContacts, have the user pick the name from the list and then have the 2nd field autopopulate from that same TblContacts with their email respective to the Name entered in field 1. My form has two field [Traveler] and [Email]...The tblContacts two fields are [Name] and [Email]

Code:
DLookup("[Email]", "tblContact", "[Name] = [frmEmail]![Traveler]")

View 5 Replies View Related

Tables :: Auto Populate Fields In A Database

Dec 6, 2014

I have a table called Jobslog which contains records for my permanent jobs I have to do for customers in one week.Structure is like:

JobID
TeamID
DayName
JobDescription
Instructions

Each job is assigned to a team, but is following same schedule every week.Can I create like a module or query to autopopulate the table with next week jobs, but putting the date as well, not only day name.For example, each Monday job should have a date field which should be 8/12/2014, Tuesday jobs should have 9/12/2014 and so on until Sunday.Usualy they are more jobs for each day (not day and job).

View 2 Replies View Related

One User Of Split Database Front-end Can't Launch A Form

Jun 25, 2014

I have a 2007 back-end db on a network share and around 15 regular users who access it through their own front-end db/interface. One user on Windows 7 is able to launch and use his front-end copy fine except when he goes to launch one form for data entry.

This form clocks and freezes the entire application. I sat with him and was able to determine that the issue is that the form_load code is never running. He clicks on the button to launch the form (done in vba) and the code never runs. If he opens the form in design view first then changes to form view, the code runs fine and there are no issues. This is his present work-around, but I had to give him an unlocked FE copy to pull it off (not ideal!).

I tried this with him on different PCs, with different front-end copies, and even in the back-end copy. Same result each time. None of the other users have this issue, and he can replicate this issue on different PCs. I'm at a loss for what might be causing this since it really seems so user-specific.

View 6 Replies View Related

Cannot Move Database Up To Front View Behind Form Switchboard

Apr 13, 2012

Hard to see the image but basically, I can't seem to bring the database behind the form to the front to view it when I click on it. I've never encountered this before.

View 5 Replies View Related

Modules & VBA :: Keep A Form At Front But Still Be Able To Use Other Forms

Nov 5, 2014

I am after a script to lock a userform to the front but still be able to work on other forms.

I have an excel userform in access which does this and better still it is like a sticky note as it stays on the screen even when going to another program, but as I am working in vba all day long, every time I change something the form closes, it works great when not using vba though.

View 14 Replies View Related

Forms :: Create A Navigation Form On A Split Database With Front End And Back End

Apr 4, 2013

I am trying to create a navigation form on a split database with front end and back end.But Access is not letting me drag forms or reports into the navigation form. Why?

View 1 Replies View Related

Modules & VBA :: Form Stays In Front When Table Opens

Jul 6, 2014

I have a Form with a control button that opens a Table using VBA code.

I have made quite a few similar databases before and usually when the Table opens it opens "above' or in front of the Form.

This time the Table opens but behind the Form.

I would like the Table to open and appear in front of the Form.

Is there a setting or something to control which displays on top?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved