Question About Auto FE Update Utility

Dec 28, 2006

Hello,

I have added this to my database but dont see how it would be used. I have a shortcut people use to access the database which ties in my workgroup file infomation so that they can open it.

Now when I send the MDE file to people they get the "dont have permission" typical response.

Now if people are goin to use the shortcut to the either my .mdb or .mde then couldnt I just make adjustments to those and then replace the file on the shared network?

Am I missing something or not seeing how this would be useful or needed?

Thanks for any insight.

View Replies


ADVERTISEMENT

Auto-insert And Auto-update Help

Sep 1, 2005

Hi all!
I was wondering if you guys can help me out with this one:

I would like to have data auto-inserted from a particular colum in table 'x' in to a defined column in table 'y'. similary, I'd like to achieve auto-updation of this data as well as deletion. Can anyone please provide some guidelines?

A little more detail :

I have a column "Client ID" in the table client_personal_info, the rows of which I'd like to have updated in the "Client ID" column in the client_business_detail table.

So if say, ClientID_1 is a row that has been added by the user, I'd like to have it auto-inserted in the client ID column in the client_business_detail table

thanks in advance for your help

View 5 Replies View Related

Utility.mda

Nov 17, 2007

I have a small problem and think I have found the answer but still would like some info on it. I have a DB that was created in Access XP, One of the bosses upgrades to Office 07 full version, and only has Access 07 on his machine. The DB would not open for him..... I noticed the reference "Missing" to "Utility" Now when I open it on my laptop it's fine.... I have Office 03, Access 03 and Access 07. So I opened an old sample DB of something I found and I got the same reference error.... As it shows the path I found the "Utility.mda" and set the reference. From my searching it sounds like this "Utility.mda" was something on older versions but now is not on Office 07.... So what exactly was the "Utility.mda" what did it do, and why is it now gone???Thanks

View 4 Replies View Related

Utility File

May 1, 2006

Hi,

im trying to fix an access program on a computer for a friend.

I have re-installed the progam and access 2000 runtime perfectly but several errors are stopping the program running. On my computer i have carried out the exact same installation procedure and it works fine. I am therefore thinking that there must be some sort of problem with his computer config.

After quite a bit of trial and error i have found the following.

In the directory of the program there exists a file called 'UTILITY', which says it is a type 'Microsoft Access Add-In'. What exactly could this file be for? It consists of several modules and tables which seem to relevant to the program. On my computer i can go into the utility file and look at the tables ok.

On the problem computer though i can get into the file but when i try to open the tables i get an error that just says 'Unknown'.
Also after a while access then completely crashes and wants to send a report to microsoft.

Also the program has worked perfectly up until lately but no idea why this has changed.

Thanks
Andy

View 1 Replies View Related

How Can I Tell If FE Is Corrupted? Error With JET Utility.

Apr 12, 2006

The FE of my database has been crashing during the last week and there have been a few other problems. I got errors saying that the BE was an 'unrecognised format'. I remember getting a 'not a valid bookmark' error also.

Another odd thing that was happening - when I put breakpoints in my code it was not breaking and stepping through it. It was like they weren't there. I realise now that editing the code while it was in break mode may have caused problems.

I didn't realise these issues were signs of corruption (until I started reading up on the subject and searching this forum) so have no idea when it started or what could be corrupt.

I used the compact and repair facility and it seemed to work fine. I can open all the forms and reports. I also decompiled the FE and it hasn't crashed since but I don't know if the problem is completly solved. From what I've read the problem could get much worse if I don't deal with it now.

The reason that I think that there may still be a problem is teh fact that the JEt compact utility will not work. I just get an error saying 'Error compacting database' straight away.

Is there a way to tell if something is corrupt or am I worring unnecessarily?

View 5 Replies View Related

How To Track Utility Bills???

Jan 24, 2007

I'm interested in tracking monthly utility bills....monthly charges, units/volumes, costs per unit and so on, by monthly date. Would I be OK using a single table for my data, since it only involves gas, electric and water each month? How would I chart the data, so I could see trends (i.e., cost per volume, etc.)

Are there any sample projects out there that I might be able to adapt to what I'm interested in?

I'd be most appreciative if anyone has a comment, idea or suggestion. Thanks in advance!!

View 9 Replies View Related

2007 Ribbon Utility....

Jun 20, 2007

Has anyone used this tool for customizing ribbons? http://pschmid.net/index.php
Looks like it might be a time saver.... But no examples actually showing Access.

View 2 Replies View Related

Utility To Search For Tables?

Dec 14, 2005

Hi,

Totally new to access and was wondering if there is a way to search all queries, forms, macros, etc for references to a particular table. For instance, I am adding keys to some existing tables that do not have keys and want to test all the forms where that table is used.

Its a big database and going through form by form will take a long time.

Thanks,

sal

View 2 Replies View Related

Modify Bob Larsons FrontEnd BackEnd AutoUpdate Utility

Nov 22, 2007

Hello everyone,

I was looking for a great way to link and relink BackEnd to FrontEnd and I sort of found it.
Bob larson build a great extensive tool to autoupdate backend en master frontend. You can find his great post here: http://www.access-programmers.co.uk/forums/showthread.php?t=111132&highlight=back+end

Here is my problem or wish is more appropriate.

I just want to relink the backend and if the backend isnt found I want to select it using the filedialog.

Who can help me...
Perhaps you can Bob???

I included the file

I realy hope that you can help me guys.

View 1 Replies View Related

Auto Update Of A Db

Nov 24, 2005

If am a developing the db and just making alterations to forms and reports etc on a developing copy. Is there anyway i can auto pull and replace the ones in the live db rather than going into the live db, deleting all the forms etc and then importing it?? can it be scripted or somethign like that?

Thanks

View 1 Replies View Related

Auto FE Update

Dec 21, 2005

hi all
i searched for this but didnt get it clear. how can i update the FE for my users?

View 1 Replies View Related

Auto Update..how?

Jan 19, 2006

Hi...Im working with this database..its an order tracking database.. everytime we received the shipments we have to update the rcvd items.. i have an attachment here... pls i really need help...

How could i do these automated:

1: if i update the Rcvd status (Y/N) "Y" ...how could i make the Date Rcvd automated.. coz what happens is that.. i have to put date in each items that we rcvd and its a waste of time.. what if.. i have lots of rcvd items..

2. how could i put row count.. so i could know how many items i have and on what row are they...

pls help..

thanks in advance....

Eric

View 5 Replies View Related

Auto Update In Form

Nov 28, 2005

I have a form I need to enter basic info into, and would like to know Iif there is a way based on the primary key id when I enter info on an individual's account, the rest of the info will get updated, i.e. contact info, full name, etc.?

Thanks.

View 1 Replies View Related

Auto Update Fields

Feb 17, 2006

Could someone please shed some light on any methods on a way to update fields automatically in different tables but with the same field name when data is entered into one of the fields in any table?

Thanks

View 3 Replies View Related

Auto Update Form

Sep 21, 2006

Sory about my english.I have a table that records data.Name-Surname-adress-payment time etc.The payment time is very important because all event is progress around this.Is that possible to remind me before the payment time?Thank you very much for your help.

PS: I send a photo about my question.

View 1 Replies View Related

Auto Update/reload

Sep 26, 2006

I am building this little project for work, and came up with this problem.
It's basically a database of the works in the workshop.
Each car comes in, the service advisor adds a new job in to the database.
And at the other end of the workshop, ppl can see it on the screen.

What I have managed to do now is that if someone modified any details of the existing jobs, it will be automatically updated on the other computer.

(ie, computer 2 has a form opened and showing all the current records in a continuous form view, computer 1 modified 1 record, then a couple seconds later, the form will update itself with the new data on computer 2)

The problem now is, if computer 1 ADDs a new record, it will not show up/auto update on computer 2's form, until I close the form and reopen it again.

Now I have no knowledge in VB and have no idea on how it work together with Access. I do however has some skills in other programming language like Java and C, so learning shouldn't be a problem if that has to be done through VB.

Any suggestion?

View 4 Replies View Related

Auto Update Form

Nov 12, 2006

I have a database with a Source Table related to a Product table in a Master/Child relationship. The source table has a SourceID field as the primary key and a SourceName field. The Product table has a SourceID field as a foreign key and is related in a many to one relationship to the Source table (the source table is the one and the Product table is the many).
I have a form used to update the Product table. The form includes Combo Box controls for both the SourceName field (which fills in a Source field in the Source field in the Product table) from the Source table and the SourceID field from the Source table (which fills in the SourceID field in the Product table). I need to know how to automatically fill in the SourceID control based on the selection made in the SourceName control.
I would also like to know how to automatically open a form to update the Source table if I enter a SourceName in the Product.SourceName Combo Box that isn't already in the Source table.

If you can help me, please send your replies to james.ballotti@gmail.com

thank you

View 1 Replies View Related

How To Auto Update A Report

Aug 18, 2013

i have a complete access database with forms and queries and reports.

the only problem i am facing is that when i create a new report it only takes the data already entered.

if i modify or change a record in the form or table the report doesn't update the modifed data it stays as it is before and i have to re-create a new report.

is there any way to deal with this and make the same report auto refresh the data modified or no ?

View 5 Replies View Related

Auto-Update Front End Question

Feb 6, 2007

I was looking at Bob Larson's utility posted here (http://www.access-programmers.co.uk/forums/showthread.php?t=111132) and I have a question. Maybe I'm being dense (I probably am) but the loading page on my form looks like this:

http://farm1.static.flickr.com/177/382115209_23c11d6896.jpg

I was just wondering if Bob (or someone else) can tell me what the difference is between the first and third options on this page?

View 9 Replies View Related

Auto Update Field On Click

Apr 30, 2005

Hi after I searched the forum for a solution similar to my problem I did not find anything that worked.

I have a form that it is used for hiring DVDs.

There are fields among others like customer_id, copy_id and a hired field wich is true or false.

I also have a submit button which saves the record before you finish. I would like to make the hired field for this record updated to value "true" when I click the submit button.

View 3 Replies View Related

Auto Update Field On Click

Dec 27, 2005

Hi all

I've followed the instructions on this post:

http://www.access-programmers.co.uk/forums/showthread.php?t=85898&highlight=updating+field

But, unfortunately doesn't seem to be working for me.

I added the equivalant field to 'Hired' after I had previously made tables etc and started added code to forms etc.

When I type Me. a list of options available to type in appear, and 'Confirm' (my equivalant to Hired) does not appear, yet all of the other field names in the form associated to this table DO appear. Does anyone know how to get around this?

I've also set my field to be "Yes/No" - does this mean that the code is:

Me.Confirm = True

OR

Me.Confirm = -1
?

Many thanks

View 5 Replies View Related

Problem With Auto Update Control

Jan 15, 2006

Hi.
I am new in using Access, so forgive me if the solution for my problem is easy.

I wrote for customers a little program, which receives data via RS-232 serial port and then place readed data into MS Access database. After i put the data into field in table (database, table and field are set in my program), there is some kind of script that continue the process of data manipulation.

The problem is, that customers want to activate that script automatically, when i place data in the field. So, i made a form, which contains bound control to this field. Every 2 seconds i am refreshing this form, so when i change the data in the table field, i can see the change in the form control. Now, how can i make the OnChange event to work, when the data changes? I tried to do it, but nothing happens, except if i am writing from the keyboard something directly in the form.

Can this be done and if, how must i do it, so when a new data arrives to run automatically the client script?

Thank you in advance

View 3 Replies View Related

Auto Update Of 1 Field Based On Another.

Jul 6, 2006

i have set up a database to help track the vehicles my company owns. However on the form i have created when i type in the license plate number want the work area that is responsible for the vehicle to pop up so i can inspect it.the form also has the different things i would look at but i don't want to continue to change the work area that has the possession of the vehicle or have to look it up every time i have an inspection come due. Any help would be appreciated

View 1 Replies View Related

Forms :: Auto-update Date Field

Oct 14, 2013

Is it possible to automatically update a date field in a form record without ever clicking in to that date field, but only because you have altered something else on that individual form record or an embedded, linked subform record? eg1. Staff details record - a) create a record for Bob Smith and 'Last Updated' field automatically inserts date b) amend record to say 'Robert Smith' and 'Last Updated' field changes to show new date, even though you never touched that date field. eg2. Risk register - main form record contains name, details, and 'Last Updated'; embedded subform allows you to add individual records of actions taken for each risk. I want the 'Last Updated' field to update each time I add an action, without amending the 'parent' risk record.

View 10 Replies View Related

General :: Auto Update Of Distributed MDE File?

Jun 3, 2014

We keep a backend and a master frontend of a database on a network drive and distributed a .mde version of the frontend to the users who save a copy of it on their hard drive. There is a separate version table on the frontend and backend of the database for version comparsion. Whenever there is change on the master frontend, I shall change the version # on those tables and make a new .mde file on the network.

When user open their own mde frontend, there are scripts to check its version with the master frontend on the network and any mismatch will trigger off the following scripts (on the default form) to replace the old version with a new one from the network.

Private Sub Form_Load()
Dim strFEMaster As String
Dim strFE As String
Dim strMasterLocation As String
Dim strFilePath As String
' looks up the version of the front-end as listed in the backend

[code]....

This process works fine for everyone in Access 2010. However, these scripts appear to have conflicts with Win 7 when users upgraded to the O/S. They keep getting database unstable error message and the process fails to work. Whether we can change the scripts to make them compatible with Win 7?

View 14 Replies View Related

Forms :: Calculating Fields And Auto Update

Jun 15, 2013

In this table I have two fields Seats Available and Seats Remaining

When I register a student to a Course in the Courses table I would like the corresponding Seats Remaining field for that course to decrease automatically.

I can, of course, run a report or a query to see how many are enrolled in the course and then manually update the Seats Remaining field (which is what I currently do), but I would like this process to be automated each time I register a new student.

View 4 Replies View Related







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