Creating Unique Id On Remote Pc
Aug 21, 2005
Hi all,
Got my job database going quite well, at the moment, it generates a job number form the first 4 letters of the customers name, and the ID (autonumber), so for example mr smith's job number would be SMIT0012 (assuming the 12th entry in the database)
Now this works fine, tables are linked and the database access the tables via a mapped network drive for other pc's (2) to use. But the problem is, if the database user were to be at a remote location with a laptop, how could this work? I could use a local copy of the tables but then of course the ID's wouldnt match! Can anyone offer any ideas on this?
Thanks
View Replies
ADVERTISEMENT
May 20, 2005
I am very new to db programing so please forgive for such a simple program.
Here is the deal. I have a db for about 500 students.
I would like the table [Students] to create a unique ID "number" for each student. I would like the number to be based on information from the same table. For example if the student's name is John Doe and his number is 555-1212 then I would like to the id to be JD1212. I plan on using more than name and phone number but this was just to show you, what i am trying to get done.
I can do this using a form and a calculated control, but I can't get the table and form to kiss and make up. I was also told you can't save data from a calculated control in a form to a table and it is gernerally not a good idea, so I was told.
Any help would be appreciated.
Sincerely,
Pastor Nick.
View 3 Replies
View Related
Aug 22, 2004
i was wondering how to go about doing this, i currently have a query which returns all the payments due in the next month, going to a report which acts as an invoice. I was wondering how to create a unique id for each invoice and store the last id so that i can automatically itterate it later
View 4 Replies
View Related
Aug 21, 2006
I'm working on a database that has to be done in Access and in coming up with a unique ID for each worker I want to take the first letter of the first and last name and the last 4 digits of their social to create the UID for the table. So for FIRST_NAME:Homer LAST_NAME:Simpson with SOCIAL:123-45-6789 his UID would be HS6789. Is there a function within Access that would allow me to do that, or is that something that's just too advanced?
View 9 Replies
View Related
Feb 20, 2007
Hi all,
I have been trying to incorporate an access DB in to our business for sometime, but keep coming up against the same issue. We have a numbering system for the jobs we do, which was invented many years ago and cannot be changed. It is in the format "month/Year/unique 3 digits" the 3 digits are sequential, i.e. 02/07/123 ... 02/07/124... etc. I will need this all in one field.
So far I have managed to get the month and year (easy enough) with the expression "=Month(Now()) & "/" & Right(Year(Now()),2) & "/"" Now I need to get the sequential 3 digits at the end, however, I am not sure of any way to do this and it has stumped many people. I have a field that is autonumbered, but don't seem to be able to add this to the end of the expression.
If any of you have any suggestions I would be greatful - bear in mind I am only a begginer at this.
Thanks in advance.
View 8 Replies
View Related
Aug 19, 2013
What I have is a small POS system I'm trying to create a unique invoice number for each transaction (multiple records)
I have two tables, one named "CurrentTransactions" and one named "Past Transactions".
I have everything working except the invoice number my system works by adding pre defined records into the table "CurrentTransactions" and once the sale has been finalised it transfers the data to the "PastTransactions" table.
take the last number from the "PastTransactions"."InvoiceNumber" to create an invoice number in the "CurrentTransactions", and I want to be able to do it using an expression in the default value property as opposed to in the form ( I've tried the form way but using Dmax would require me to almost rebuild my entire POS system )
View 5 Replies
View Related
Jul 18, 2005
Hi,
Anyone know how to create a combo box that has unique month and year entries from a table (month in one column and year in another - i.e. 2 columns)?
I've been able to get the textbox of the combobox to output the correct format using a custom format but it does not affect the combobox data. Also, I'm not sure how to separate this by two columns...
Any help would be much appreciated!
View 2 Replies
View Related
Feb 15, 2013
I have a rental database and I print several contacts for leases etc. what I want to do is have a unique reference number or something inserted to the report every time that it's printed. What I am trying to achieve is to keep track of which tenant corresponds to the report (Lease) printed by using reference number.
There is a seperate form which holds the tenants details and I would like to have a field on that form which would show the same reference number as the report so I can track which report was printed for who.
Whats the best/easiest way to accomplish this?
View 1 Replies
View Related
May 31, 2013
I'm creating a database using existing data from an excel file full of contact details. What I need to add is a queue type system where each contact in the database has a "Place in Queue" number which is unique obviously.
Lets say Alan is number 1, Bob is 2 and Chris is 3. They have these corresponding numbers in the queue field for their entries.
Now what I need to have, through use of a form, is a way of changing Chris from number 3 in the queue to number 1 and thus have Alan automatically shift down to number 2 and Bob to 3.
View 4 Replies
View Related
Jul 11, 2006
I've been looking around and it seems to be impossible to connect to an mdb file on an ftp (for Access 2002 and below). I'm using Access 2003 so does anyone know if it's possible in this version?
View 3 Replies
View Related
May 18, 2005
We have an Access Database split between front and back-end. The BE is 50Mb and the front about 60Mb. We have a requirement to provide access to the database to our other branches all of which have broadband.
I have been trying to find out the best way to achieve this over IP as we do not want the considerabe expense of leased lines. Originally we tried VPN but access seems to be very slow and appears to prohibit that route.
We were advised by our PC support company for one branch to use Terminal Services. However we do not currently have a powerful enough server to support these. We have a price for a server upgrade and it seems OK. I have since been advised by the PC support company at another branch that because of the upload speed on broadband (256Kb) Terminal Services would not be sufficient especially if we were using HTTP and VoIP over the same connection.
Looking at the various posts on this site it would seem that VPN and TS are suitable for some. Is there an easy way of calculating whether or not TS will work at our site? Has anyone gone down this route and found it not to work?
I'd be grateful for any feedback.
Thanks.
View 2 Replies
View Related
Nov 8, 2005
Hi everyone, I'm just a newbie in DB programming and I'm having a trouble:
I have a database located in my IIS server: "c:inetpubwwwrootwebapplication1dbs1.mdb".
I'm also developing a VB6 app in another computer which will access to my IIS server to get data in my database. I'm using ADODB, but I don't know how to establish the connection as well as to get the data from the server (remote machine).
Can anyone in here help me by showing an example in VB6 code?
Thank you very much, any sugestion is welcome
Reply With Quote
View 3 Replies
View Related
Oct 4, 2006
I have a database on a server that is accessed by mobile clients using laptops (broadband)
when out of the office. They use'virtual private network service' to do this.
(I did not set this up, I just design and program the front and back ends)
However some report a slow response time when retieving data from the database file.
Would 'Active desktop' be any quicker?
Any suggestions on how they might speed things up, would be most welcome
'Replication' comes to mind but I think their data must remain up to date at all times.
View 3 Replies
View Related
Nov 6, 2007
I have an Access database which we inherited and it has linked tables (2 database files, one with data tables and one with forms, queries etc) - the links being set to a path on our local company server. We are in the process of opening another company office in another part of the country and we want to use the same database system. I have taken a copy of the database, cleaned out all the existing data out and now need to send the blank database to the new office. Is there a way of forcing the database to reset its table links when it runs in the new location (or pre-defining the paths before it is installed)...rather than my physically having to go to the new office to use the Link Manager when in situ.
I wondered in fact whether was a way of holding the required path statement in one of the tables so that the links could be easily reset on any future installation. I do not know how to code anything like this or set it up - I am new to Access databases
Could anyone advise please.
View 2 Replies
View Related
Oct 10, 2005
Ladies and Gentlemen,
I'm sure you gurus have an answer for me.
I have a MDB (MS Access 97 db) on a shared drive. All my data resides here.
I have a local MDB (MS Access XP db) on my hard disk. Currently, I have queries located on the shared MDB that puts out a table. I then execute queries on my local DB, linking to the table I have on the shared db.
My requirement is this.
1. I want to be able to run queries against the shared db from the local db.
2. When the create table query is run, I would like it to create the table in the local db. I can live with creating the table in the shared db, but local would be better.
I'm sure that this can be done. I've seen it. But, that has always been a client/server system.
Thank you.
View 1 Replies
View Related
Oct 13, 2004
I have two databases; a server and a client. The server houses all of the tables, while the client has the tables linked and serves primarily as a form for users to enter data to the main table. Periodically I update the form, so I would like to be able to shut down each client while I upload the new files to update the client. Here is my thinking:
I have a table in server.mdb called admin with 3 columns and one record.
The fields are:
closex (text) - This will be populated when I want to send the close countdown command.
message (text) - The string I want to display in a warning popup box.
Timer (integer) - The time in seconds before the program will close.
Right now I have a hidden LIST box in the form (closemsg) that is bound to column 1 and column count=3.
Me.closemsg.column(0) is closex
Me.closemsg.column(1) is message
Me.closemsg.column(2) is timer
The box is requeryed every 2 seconds to check and see if the table has been updated along with another line of code that keeps the time current until someone starts to enter a record.
I have a macro that will perform the close operation. Here is the code I have thus far....any help would be greatly appreciated.
___________________________________________
Private Sub Form_Timer()
'Updates the Time to Current
If (IsNull(Agent)) Then
Me!Call_Time = Time()
End If
'Checks for updated values in Admin Table
Me.closemsg.Requery
' -------------
'| Force Close |
' -------------
'Message Variable from T.Admin
Dim message As String
'Timer Variable from T.Admin
Dim timer As Integer
'Macro Variable to Close App
Dim macroname As String
macroname = "Closeapp"
'Check to see if T.Admin has changed
If (IsNull(Me.closemsg.Column(0))) Then
Else
message = Me.closemsg.Column(1)
timer = Me.closemsg.Column(2)
'Set Timer
timer = timer * 1000
'Notify User
MsgBox message
Count:
timer = timer - 1
If timer > 0 Then
GoTo Count
Else
DoCmd.RunMacro macroname
End If
End If
End Sub
View 5 Replies
View Related
Jan 9, 2005
So im starting to have a lot of the same buttons to search and go threw records in in diffrent forms.
Ifigure to save space i can make ,or a form that cotains all the buttons or a personalized menu bar on top with access.
But i rather have it on a form,
First things first i am having a lot of trouble with the mos t basic part of it all. i cannot seem to control the simplest
GoToRecord , , AcNext
I have an error that always says you cannot go to that record.
i have an open form called "Calls"
Forms("calls").form.apllication.docmd.gotoRecord , , AcNext 'is the buttons on_click event.
And i figure with a combo box on the navigation window i can add witch form i should be controling Like a tv remote that has vcd, tv , dvd. but i cant even get the simplest thing working any addvise would be apreiciated.
Mark
View 2 Replies
View Related
Aug 8, 2005
Hey all,
I'm trying to set up a database in Access which, in the end, I'd like to be a copy of the master DB, but with all the tables linked. the goal is so that it is smaller in size and less volatile (since it detaches the users from the original db).
The main DB is currently located on a server where we host our website, and I have mapped a network drive to the directory that holds the database. In the client database I'm trying to build, I've attempted to link the tables via the network drive, and then import the rest of the database. Doing it this way just gets me a broken database application.
I've tried creating a system DSN, but all that seems to do is map the network drive. The original way this was done is using a SQL Server driver to a different server. Should I be trying to set up our master DB this way, as a SQL Server? I'm almost completely new to database programming and I apologize for the hand-holding questions.
Thanks for any help you can give!
-K
View 4 Replies
View Related
Jun 22, 2005
I am currently attempting to setup a database that will be used by many people. I have the database setup and it is split into a backend (tables and data) and a front end ( forms, queries, etc) which the users will download and use off their own machines. I'm attempting to house the backend on our webserver.
The backend is on our webserver and I'm attempting to link the tables from the front end to this location. I typed in the webaddress into the open menu after selecting the Get External Data --> Link Tables menu item. I am sure that this web address is correct because I copied from my browser (from which I was able to download the database from). After I put in the web address into the open box, I get an error about not a valid file name. Is there something I'm not thinking about? What could be my problem? Is it permissions maybe? Does there need to be something special setup with the backend or my webserver? Any ideas as to do with the problem would be greatly appreciated.
View 3 Replies
View Related
Sep 23, 2005
I have an Access database on my server. My client does not like the idea of having to download the db, make changes, then upload it back. In the past, he has dealt with SQL databases, where you can create an access data project, that will give you a desktop shortcut straight to the database. I was wondering if there was any way to do something similar with an Access database. There is FTP setup for the site and all required permissions are setup. Is there any way to create a desktop shortcut, so he can edit the database in real-time, without having to download and upload? Thanks for any help.
View 3 Replies
View Related
Feb 7, 2006
Hi :)
I'm currently in the process of testing security before shipping my database off. I have read the access security faq, but I'm not sure which option to go for. The main factor that makes me doubt, is that the db will be sent to locations that I will not be able to physically get to myself. I am hoping that some of you have some experience on dealing with remote installations of your databases.
Option 1:
Use one workgroup file
make a user_admin user which is NOT member of the admins group
rename the workgroup file to an mdb, open it and give the user_admin permissions to edit the user and group table
The problem with this approach is that the user_admin can assign any user to the admins group, which basically defeats the whole purpose of this option really.
Option 2:
Use two workgroup files (development/securing and distribution)
make the user_admin a member of the Admins group in the distribution file
As the Admins group is different in the distribution workgroup file, it is impossible to change any database object. The only problem is if something were to go wrong (which I think is highly unlikely :D ) it might be good to be able to manually walk the user through fixing the problem, and to do that it is likely that some database object needs changing, therefore needing an admin login...
comments or suggestions welcome :)
Thanks again :)
View 2 Replies
View Related
Apr 6, 2007
Hi, I am just about to install a database on another computer 300 miles away. The db has an expiry table which prevents access when a certain date is reached. Is it possible to update that table via an update on CD or email sent to that person with a new date so they can continue using the db. (In other words a form of licence key) at the click of a command button.
View 6 Replies
View Related
Jul 29, 2007
I have developed an application for a friend. We live about 100 miles apart in the UK. The database (Access 2007) works perfectly for us, I input data from various sources and he views the reports I've designed that show him exactly what he wants to see.
Now I want to move to the next phase which is I enter data from my PC at home and he then views the reports on his PC at his home.
Any advice on how I can do this, at low cost,
View 2 Replies
View Related
Mar 5, 2008
I just found out that this years project wil be setting up a remote office location. There will be about 5 users at this location. They want complete control over all equipment. What they have in place here is Terminal Services and thin clients.
Our db is Access front end with SQL backend.
My initial thought for the remote office is:
High Speed Internet
Either CAT5 to each desk or Wireless Access Point
5 thin clients.
Using RDP they should have no problem accessing our network unless they can't all use the same public IP address for our main office.
The other thought is Setting up a Point-to-point VPN. My biggest problem is I havn't worked with thin clients until I started working here. I don't know what I would need at the remote end in order to connect the thin clients through the VPN. They don't want any servers or desktops if we can help it.
Does any one have any suggestion or thoughts on this?
Thanks,
Dan
View 2 Replies
View Related
Oct 23, 2004
Hi all,
Is it possible to make a backend/frontend access system and putting the backend on a remote internet server.
E.g. http://www.mysite.com/database/backend.mdb
Because when I try this I keep on getting a message "Not a valid file name."
Any suggestions apart from RTFM?
Thanks,
Bud.
View 2 Replies
View Related
Jan 27, 2005
I have a FE database with all the forms, reports, etc. and my BE DB with all the tables is in the same directory as the FE. My problem is when users are not in the office and opens the FE data base they get an error that the path to the linked tables are not available.
My question: Is there a way to make these FE links to the BE dynamic. I really don't want various FE with paths linked to the BE.
View 2 Replies
View Related
