POS System with MS Access

Hi,

What are the primary reasons why I should not consider using MS Access to build a Point-of-Sales system? I am not too proficient with VBA, but I can get around and I can create the heck out of forms. I understand mySql is much more robust in terms of database, but it is just not that user friendly to me.

My system does require multiple stations, therefore, there may be multiple concurrent users at a given time.

Latex


Post your answer or comment

comments powered by Disqus
Hi guys, this is me again,

I'm facing a problem with MS Access reports. I'm currently designing a small tabase used by the HR department. All it does is enter the infromation in eah received C.V. each C.V. has a unique number, which is an auto number, I named it [PK].

the Education Qualification written in each C.V. must also be entered in the database, so I designed a table for these qualification and I named it [Education] with a primary key [Serial] which is an auto number.

we enter the education qualification i.e. the certificates and the degrees starting from the highest i.e. Ph.D then Masters then Bachelor then high school. that is the highest degree has the smallest primary key [Serial]

the problem is:
I want to generate a report containing the candidate name and his HIGHEST degree. How can I do that ?

for any further questions please ask!

any help will be very much appreciated !

Regards,
CS.

Hi,

I would like to know which report writer/creator is best to be used with MS Access, Report maker, crystal report etc? I am basically looking for a report creator/writer that vcan create header, can create columns (2 or more) under the detail section with boxes/lines and also create another column section separately (also in detail section) etc.

Thanks in Advance.

Hi all,

I need Accounting program with ms access with VBA code (open source)
prepare (journals, trial balance,balance sheet,Cash flow)

Regards,

Hi, I have an Attendance Machine Installed having Face Recognition/ Biometric Function, The Software came with this attendance machine, backend is based in Ms-Access, I want to make some reports according to my requirement, The issue is that i want to connect the machine and retrieve data through My Ms-Access software, Please help me with the code to make a connection so that i can work separately without using the software that came with Attendance machine, I want to retrieve data directly through Ms-Access. Please review the attached database, There is a table named as Machine which contain configurations for the connection of machine like IP Address, Band rate, Connection String, Port etc, I dont know how to connect the machine directly with Ms-Access for retrieving Employees attendance logs, Please help me in making an interface and connection with ms-access. Waiting & thanks

Please advice of any public domain
Inventory Management System for MS Access.

Thank you very much
cWalter

Hi All,

We have implemented MS-SCC API 1.3. I am testing this with all Microsoft IDEs VC6, VB6, VS03, VS05, MS-Accesss etc.

While working with MS-Access, I am able to add an access database (containing different type of objects - tables, queries, forms, macros, modules etc) to the SCM. But when I try to create database from by using our source repository for other user, only tables get added to the database, not other objects like forms, modules. The other user has to execute "Get Latest Version" command by selecting "All" from "Object Type", to populate other objects.

While creating database, SccPopulateList() function get called from our MSSCCI API implemenation. In this function we are calling (*pfnPopulate)(…) function for all object files with parameter TRUE. But still next subsequent call of SccGet() function does not show all object files.

There is something missing in my SccPopulateList() function implementation. But can't figure out what it is.

And same scenario works very well with VSS 6.0.

Can anyone provide me some pointers?

Thanks in advance.

Regards,
Abhay

Can anyone recommend any best practices or suggestions for Configuration Management with MS Access? We have additional developers our project and have a pressing need for better CM procedures

For example, it appears that the entire Access database (.mdb) file must be put under source control... Is there any way to use version control for specific database elements, i.e forms, tables, etc?

I know that the modules can be exported and put into source control as text files-- that works nicely. I'd like to do something similar for the other database elements. I haven't had much luck exporting elements (other than the modules).

I'm using Access 2003...

Any thoughts or suggestions?

Thanks.

Hi guys,
I have a following table:

	Code:
	create table animal
(
animal_id integer not null primary key,
name varchar(40) not null,
spieces varchar(40) not null
)

I would like to fill it with lots of records which I want to insert into at time. But I don't know how I can start it

Here is my records to insert:
insert into animal (animal_id, name, species)
values ( (1,'Foxi Maxi', 'dog'), (2, 'Dodo',' duck') , (3, 'Garfield', 'cat' ) )

I've found a kind of solution with these problem using the Union All keyword, but it isn't work for me (I use Access 2003)
Quote: INSERT INTO [table]
SELECT 'x1','y1'
UNION ALL
Is there any way to insert multiple rows with MS Access?
Any help would be greatly appreciated!
Very thanks.

Hi Everyone,

I need help with MS Access :

I do have a table and a query with me. There are certain entries in the Table named LOVs-IVORY.The 2 fields are :
LOVs-IvoryRORReasonCHr0682310iIvoryHKr2933710iIvoryJPr5191810iIvorySGr0432001iIvorySGr0432101iIvoryUKr4599710iIvoryUKr4599711iIvoryQAc3507701iAIvory
I need to ensure these values are not included in the final result of the Query.I would just give you the outlook for the final derived data from which these values need to be excluded :
Order ReferenceCountryRegionCityADc0627261iAANDORRAEMEAANDORRA LA VELLAADc0627277iAANDORRAEMEAESCALDESADc0628001iAANDORRAEMEALES ESCALDESADc0631063iAANDORRAEMEAANDORRA LA VELLAADc0631491aAANDORRAEMEAESCALDESADc0631491bAANDORRAEMEAESCALDESADc0633371iAANDORRAEMEAANDORRA LA VELLAADc0634456aAANDORRAEMEALES ESCALDESADc0634456bAANDORRAEMEALES ESCALDESADc0636717aAANDORRAEMEALES ESCALDESADc0636726iBANDORRAEMEAESCALDES

Can anyone help me with this.Any help would be appreciated.

Regards,
Chetan Bhalla
MS Access Beginner.

MS Access is such a brilliant tool, so easy to use, so powerful that I sometimes think people miss its obvious simplicity, the simple ability that makes it so powerful.

I’m not talking about Relationships
Many people get bogged down in the relationship issue, working out the relationships early on and imposing them on the system. My advice is don’t; don’t use relationships, only use then when you can see the benefit, and if you do use them use them right at the end when you know how your database fits together. Incorrectly formed relationships cause problems that are difficult to locate and can cause you headaches in the development process. And they’re not necessary; your database will function quite happily without relationships.

I’m talking about Sub Forms
Yes that’s right; I said “sub forms” Subforms are what makes MS Access so powerful and so easy to use. Now you might be saying “how’s that then”? Well, in my last article “Excel in Access” I wrote about a fundamental misunderstanding of how to structure your data in MS Access, once you understand the difference between “flat file” and “relational” see note (a) you will see that sub-forms used correctly offer a simple and easy way to display information from the extra tables you have created. If you haven’t found it necessary to use Subforms then you probably have a very simple data structure or you have a problem!

Sub-Form Windows
When I said “sub forms are what makes MS Access so powerful” that’s not strictly true, I should have said it’s “sub-form windows” see Note (c) are what makes MS Access so powerful”, I know it’s a mute point because they are one in the same, you can’t have one without the other. When you drag a sub-form on to a main form a “sub-form window” is automatically created, what you actually see is a sub-form positioned on the main form, what you don’t see is the sub-form window surrounding the form; the subform window is the container containing the sub-form within the main form. see Note (c) It may seem like I’m being pedantic about this minor difference, however it’s this intermediary control, this sub-form window that has all of the power.

Link Sub & Main
The sub-form window see Note (c) has some interesting properties that you can set, one of the most interesting properties is the ability to match the field on the form within it to the matching field on the main form, by identifying these two fields, you in effect link them, causing the field on the contained form to update automatically when a new record is added to the main form. (This alludes to another frequent problem would be programmers have with MS Access, see note (b))

Fragment your Table
To use MS Access effectively (as covered in my article “Excel in Access”) particularly if you start off with data in a flat file format, then you need to modify this data structure by counter intuitively dividing it up into several smaller tables. The problem becomes “how do you display this fractured structure? Before, you had a very nice flat file in which it was easy to see how the data related together. Now you have all these extra tables which have to be combined to re-form the original data. That’s where sub-forms come in, they very neatly and easily offer you a way to display the recombined data.

Why MS Access is so Powerful
Most people start off with data in a “flat file format” they then find themselves having to fragment this nice easy to understand flat file structure into several apparently disjointed tables. This fragmentation creates the next problem, how to assemble this data into a presentable user interface? The answer “sub-forms” it is this simple ability offered by sub-forms (sub-form windows) that makes MS Access so powerful.

Note (a)
I had, and still have the misconception that "Relational" refers to relating data from different Tables via a key value. The following paragraph exposes this misconception of mine... (It’s a useful misconception so I will keep it!)

Extract:
The relational model is thus named, not because you can relate tables to one another (a popular misconception), but as a reference to the relationships between the columns in a table. These are the relationships that give the model its name; in other words, relational means that if several values belong to the same row in a table, they are related. The way columns are related to each other defines a relation, and a relation is a table (more exactly, a table represents one relation).

From:
The Art of SQL --- Authors: Stephane Faroult & Peter Robson
1.1. The Relational View of Data

Note (b)
I note from the forum where I answered questions (UKAWF) that a common problem people have is wanting to enter data into a sub-form before data is entered on the master form. This won’t work because the subform window uses the unique reference number of the main form to give the subform record the linking information.

Note (c) - (the correct term for this sub-form window is “Subform Control”) Thanks to Bob Larson for pointing out this error.

I'm not sure but when I get the time I’m going to explore this issue and see if there is a way round it. My suspicion is it will be possible but difficult to implement in a “safe” way. I’m pretty sure there’s something to be learnt about the fundamental operation of this subform master form relationship from attempting this “backward” operation and that’s a good enough incentive for me to undertake what will probably be a fruitless task.

This article was originally published in the MS Access Hints, Tips and Videos website posted on the ning platform here: MS Access your Data with Sub-Forms

Uncle Gizmo (TØny Hine) is a prolific blogger (Please note prolific does not mean good) not just blogging about MS Access all sorts of issues anything he finds amusing. He's not really bothered if other people don't find it amusing either! He is particularly amused while writing this in the third person! (I had to write this "third person" line after I saw something similar written by an MS Access book author~)

Hi, I have been asked by my company to investigate whether Ms Access 2007 is the tool we need.

I dabbled with access (2002) about 7 years ago when I was a Lotus notes developer which is why I was asked to investigate it but haven't looked at it since and it has changed a bit.

I have downloaded the Real Estate template and have played with it to change field names etc into British english and not American english.

However, I need to know whether it is possible to create a pop-up alarm from a date field as we would need to know when we need gas appliances and fire alarms checked. If not is there a calendar table that is available for Access and if that is not possible can I link it to the calendar function of MS Outlook 2007.

I have searched numerous databases for this info but it all seems to relate to previous versions and these solutions don't seem to work with the 2007 version.

Many thanks for any assistance.

Don

Hi everyone:

I'm trying to automate saving of all open documents in our computer room before performing a nightly installation of updates and a later reboot. For that I need first to save all open MS Office documents. The way I do it with most Office documents from an outside script is as follows:


	Code:
	var objAccess = GetObject("", "Access.Application"); 
//Then I'd enumerate all open documents in the .Documents property 
//and call Documents.Item(n).SaveAs() method on each of them

But for some reason I can't do the same with MS Access. Can someone suggest how do I close all open documents in it with an option of saving them As in a file from a script?

Starting to work with MS Access Project and trying to convert an existing database to Access Project.
The old database was based on DAO references, now I am converting to ADO
However I am having a problem with a DCount code that works perfectly in the Normal Access database, but not in Project with the SQL2000 backend

If I run the sub described below I keep getting the error message
Runtime error 170
Line1: incorrect syntax near '#'


the debug points to the first Dcount line
I tried a number of different formats etc but none seems to work.

Any ideas what is going on here?


Private Sub Schedule_Click()
Dim strInput As Date
Dim strMsg As String
Dim test As Date
Dim testdate As Date
Dim testdate2 As Date

Beep
strMsg = "To avoid incorrect sequencing of the planning schedule please enter the first date of the month that you want to add to the schedule." & vbCrLf & vbLf & "Please enter the daye as follows DD/MM/YY."
strInput = InputBox(Prompt:=strMsg, Title:="Add new budgeted slots to the planner")


If DCount("slotdate", "TblSlotFrame1", "slotdate = #" & Format(strInput, "mm/dd/yyyy") & "#") > 0 Then
Displaymessage "The slots for this period starting '" & strInput & "' have already been created. Please check your entry."
Exit Sub
Else
If DCount("slotdate", "TblSlotFrame1", "slotdate = #" & Format(strInput, "mm/dd/yyyy") & "# - 1") > 0 Then
createnewslotdates

Else
Displaymessage "The system cannot find an entry for the previous period before '" & strInput & "'." & vbCrLf & vbCrLf & "Please select the previous month on the budget page and create the slots for that period first."
End If
End If



End Sub

Hi gents,

Is there any particular reason for MS Access to be slow when it is connected to MSDE SQL Server thru ODBC linked tables?

Or is there any set up in specific MSDE SQL Server for Access?

Each records when I save takes time to save. Even the it delays in opening forms.

Please guide me..

With kind regards,

We have an , CMS.mdb, that is published on a Citrix server. The MS Access database has a Startup routine that hides the Database window and opens the MS Access form called frmSwitch.

If I have the CMS.mdb on my C: drive and double click it, it opens to frmSwitch and the Database window is hidden. The button on the task bar on my laptop is titled CMS  [frmSwitch : Form]. If I navigate to another form in the database the button on the task bar has the name of that other form. If I minimize the MS Access window and then maximize it by clicking the button on my task bar, it comes back to the form I was on when I minimized. This is the behavior we would expect.

If instead I use the .ica file to open the application on the Citrix server, I double click the .ica icon on my desktop, and after I log in to Citrix it opens to frmSwitch and the Database window is hidden. This is the behavior we would expect. The button on the task bar on my laptop is titled CMS : Database - Remote.

Issue: If I minimize this .ica window and maximize it by clicking on the button on my task bar, it comes back to the CMS.mdb file but with the database window displayed. This is not the expected behavior.

This is a major issue for us, because once the database window is available (unhidden) to the user, they can change data, forms, reports, queries, etc.

I'm wondering if there is something about the way Citrix or the ICA file is set up that is causing this behavior?

Dear,

I have encountered the following problem in Access 2002 with Memo fields

Start with a table (The_Table) with a Memo field (The_Memo_Column)
I would like to populate this column from a edit field (The_Edit_Field) located into a Form (The_Form)

When I enter a large sentence in the edit field (seems more than 512 char ????)
and When I manage the memo field through a insert SQL query The text stored in the Memo field
is truncated and ends with strange āई characters sequence

By the way, when I manage the information directly through the standard Ms-access method


Action using a SQL query

I create a insert query

The_Query=
INSERT INTO The_Table (The_Memo_Column) VALUES (Forms!The_Form!The_Edit_Field);

On click on a button, I call the query as follow

DoCmd.SetWarnings False
DoCmd.OpenQuery The_Query, acNormal, acEdit
DoCmd.SetWarnings True
Action using the ms-access standard method

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70


Thanks in advance for your help !


Aloha

PYC

Hi folks,

I'm new to MS Access and these group forums, and have just taken over an admin role, so please bear with me.

I'd like help with the following. Just nearly had a catastrophe with MS Access, but luckily I've managed to get it back to what it was this morning.

We have a Task Database, set up years ago, which is held on a centralised server, and each person accessing the database has a folder called C:/Task, with a Task.mdb icon, which then links to the main database. This works OK.

I also have a database on another server, which is used for logging problems, and handovers. I've set this up as a One stop shop, with a nice front view, from which I have links to all our databases, and other documents, one of which is the Task Database. This worked fine until this morning.

What I was attempting to do was to setup access to that it recognises the person logging on, and instead of saying Hello Admin, it will say Hello xxx.

I tried setting up a new multi user environment, by updating the Workgroup Administrator. I set up a new .mdw file called system.mdw, which worked on my task database, when I logged on directly.

However, when I log on via the front database, it won't open up the Task Database, as it says that the system.mdw file is in use.

Is it possible to set Access up, so that you can use logon account on more than one DB ???

I've now reset the Workgroup Administrator to point back to WINNT/system.mdw, and it now allows me to access the task db from my front db... So, I'm back to square one.

Please, please can anyone help?
Ta
Karen

Hi all,

having some serious troubles with a MS Access 2000 project running on a Windows 2003 Server environment.

If I compile the project it doesn't produce a compiling-error. Everything seems to work fine. Creating a .mde file and running it on a Windows Server 2003 produces some serious errors. The project seems to be starting correctly but opening a form or simply trying to close the application causes MS Access to crash!

I tried the project on 2 different Windows Server 2003 environments, 1 having MS Access 2000 installed and 1 having only MS Access 2000 Runtime installed. Both are experiencing the same problems.

The following references are used in the project:
- Visual Basic For Applications
- Microsoft Access 9.0 Object Library
- Microsoft ActiveX Data Objects 2.6 Library
- Microsoft DAO 3.6 Object Library
- Microsoft Jet and Replication Objects 2.6 Library
- OLE Automation
- Microsoft Office 9.0 Object Library
- Microsoft ADO Ext. 2.8 for DLL and Security

I tried the following solutions to solve the problem:
* Removing MS Access completely and reinstalling it.
* Compiling and creating a .mde on the Windows 2003 Server which has the full version of MS Access 2000 installed.
* Using JetComp to repair the database.
* Creating a new MS Access 2000 application and copy all Forms/Modules into it.

Nothing helped so far..

The same project is running correctly on Windows 98, ME, 2000, 2000 Server and XP Pro/Home. Both Windows 2003 Servers are fully updated, including updates regarding MS Access.


Help...

I've been having some problems with sharing an MS Access 2000 database across a network.

The database is setup to open in shared mode and has been tried both with and without record locking, with the same issue occurring.

The main users are:
User 1 (Administrator) - MS Access 2000 Full Version (WinXP Professional)
User 2 - Access 2000 Runtime + Access 97 (Win XP Professional)
User 3 - Access 2000 Runtime + Access 97 (Win XP Professional)

The problem is occurring when User 3 opens the database. For some reason it opens in exclusive mode and locks out Users 1 & 2. This issue only happens with User 3, and does not happen with User 2 who has the same software setup.

The database was previously an Access 97 database (no problems) and has been converted to Access 2000, this share issue has been happening ever since the conversion.

Any ideas as to how this shared issue could be resolved?

BTW - I am familiar with FE/BE setups. This database is accessed by all from a network drive and not setup as FE/BE. This was never an issue, as shared access worked fine when the database was in Access 97 - the problem has only been since converting to Access 2000. I do not have access to the PC of User 2, and User 2 does not have any PC knowledge to install a FE, which means I would need to create an install package (which I'd rather not do). Are there any ways to resolve the shared access issue without changing to FE/BE?

I am an administrator of a replica-set of 13 MS Access 2000 databases. The size of each one is around 1Gb. Some of them are located in one office (with LAN). The rest are in remote offices. We have a VPN between remote offices (not much of a throughput – usually 500 kbps). We are using Replication manager (mstran40.exe) to make indirect synchronizations with them.
Usually we make 3 - 4 (or more) synchronizations of remote replicas with the Main office per day. Additionally we make synchronization in-between remote replicas on daily basis.
I have the following problems:
1. When we make direct synchronizations between replicas in the main office (LAN) they usually are slow. If one of the synchronized databases is opened for office work the synchronization is extremely slow. Note that exchanged records are not a big number – mostly several hundreds up to few thousands. The hardware is oversized.
2. When no synchronization has been made for one or two days the database grows to the maximum size - 2G and gives an error message:
An error occurred while using the partner member in the replica set; UNKNOWN REASON (-1003)
3. Another frequently appearing error is: Out of temporary disk space. When I change the MaxBufferSize key in registry to 500 000 the synchronization is successful, but if I leave this value, after compacting database becomes not-replicable.
We use this database for several years and I keep look for solution to these replication problems, but still have not find a stable solution.
I will be very grateful for some help or suggestions on resolving this.

Hi all,

I have a VERY weird problem with the MS Access 2010 date picker that I hope someone could point out to me what I did wrong. I have a main form with a subform in Datasheet view. The problem occurs in a Date field in the subform.

In normal circumstances the date picker seems to work fine but sometimes when I open form to add new records nothing happens when I select a date in the date picker. I've tried every process I can to eliminate this problem but I can't seem to find an absolute answer. It just happens when I use the form "as intended" but doesn't seem to happen when I go into Design Mode and back etc and this really adds to the frustration...

Can anyone think of why nothing appears when you select values in the MS2010 date picker?

edit: I would like to add it is fine if I manually type in the date though... I also have Data Validation active on these "cells" but I don't think that should matter? I also have an After Update check but when I go into Design Mode and back it seems to work fine! It's just when I open the form from my main menu this doesn't work... Frustrating!

Cheers...

Currently there is a MS Word application that runs a MS Access query to generate data for the Mail Merge with a document.

Does anyone have a suggestion as to how this process can be optimized? Specifically, looking to reduce the amount of time required to produce letters (best practices).

Thanks.

Hi Guys,

This is the first time after school that I am trying to use ms access at work and i need ur help in creating a query.
Any help will be highly appreciated!!

Here is what I need...

I have relatively small ms acces database with about 1000

I have 3 colums

date ipaddress sitename

12/09 34.3.3.3 A
12/09 34.3.3.3 A
12/09 34.3.3.3 A
12/09 33.4.4.4 B
12/09 33.4.4.55 C


What i need is if an ipadress is recorded more than 2 times in a single month for instance (34.3.3.3) put those ipaddress with the Site-Name in a seperate table.

Any ideas?

Okay guys, i have two weeks to make labels for 500 VHS and SVHS tapes, put them on a shelf, and get the new Tape Library system in order. I've been working on it all year, have all the info i need, but am running short on time now.

I recently had a computer failure where all of my already made tape labels were deleted, but i had a safe copy of the excel file holding all 500 tapes secure...but not the labels of them. So, i need to make several hundred labels ASAP. This is my senior year in high school and i'm the only one who knows the system and won't be able to teach anyone until AFTER the system is set up. This is my grade and ultimately my graduation. I MUST GET THIS PROJECT FINISHED.

My problem is that i'm not so familiar with MS Access and don't know much about it. i do know that you can import information from Excel to Access and let it fill your form that you've made, i know that much, and my little brother showed me that, but we, including our teacher here at school, cannot figure out how to import the data from the excel file to make MULTIPLE forms instead of sending it only to ONE form...how do you do that?

If i can do that, it'll save me a lot of time and already spent work.

I desperately need this information ASAP because if it cannot be done then i need to work night and day to manually type out these labels.

Thank you,

CD


Not finding an answer? Try a Google search.