Hello ! I'm having a university project where I have to make a database on MS Access . The subject is : We have a company that deals with trading. You need to make a database to serve cost and product discounts for customers. The database must contain : -Nomenclature of customers with fields of your choice -Nomenclature of items with fields of your choice -Nomenclature, which represents individual prices for certain items pertaining to specific customers. When selecting a customer, the database must show all items with the respective prices depending on whether a customer is using it individual …

Member Avatar
Member Avatar
+0 forum 4

We have a MS Access database located on a shared drive. Is there a way I can allow multiple users to access and update the database at the same time?

Member Avatar
Member Avatar
+0 forum 6

Hi I am useing Lazarus and a odbc connection to connect to a MS Access database I connect fine and get all records displayed in a dbgrid . My problem is to get the changes written back to the db. When i try to write the data back to the db I get the error : DBConnection: No update query specified and failed to generate one. I do the changes in the dbgrid and do a SQLQuery1.ApplyUpdates; Please help Thanks

Member Avatar
Member Avatar
+0 forum 1

Hi Experts, I had completed a database in vb.net with access database. Now my question is, how to make it accessible online? Thanks.

Member Avatar
Member Avatar
+0 forum 3

Hi good day guys.. i am doing a POS in Microsoft access for my thesis.. the problem .. i create a button and i want to enter a data to the list box.. if you click the menu button it will automatically add the item on list box.. and i also have the table of my product it include the product name, price and quantity..thanks for you're help

Member Avatar
Member Avatar
+0 forum 2

I'm a beginner with databases and I'm trying to design a database in Microsoft Access that will allow users to make bookings for fitness classes. There are two slots per day that these classes can be booked for and each session can cater for 10 people. What I am struggling to understand is how I can limit the number of bookings made per session, per day, to ensure nobody can book a class on a session and a day that is already full up. Can anyone offer me any suggestions about how I can achieve this? I have started designing …

Member Avatar
Member Avatar
+0 forum 6

Good afternoon, Currently, I’m trying to consolidate all my financial information into one place so that I can see (the solution I’m currently using is Excel – see attached): 1. Valuation at a particular date 2 .Breakdown by investment product 3. Various other analytics (Allocation by class etc.) I’ve tried to use access, but it complains about outer joins in the excel workbook that I’m importing from google sheets (it automatically scrapes information from one of the sites that I have investments in) **What I’m using now** I’ve uploaded my info into PowerBI however, I can’t seem to create a …

Member Avatar
Member Avatar
+0 forum 1

Hello All; I usually do everything in SQL Server these days, however, I have an site that is just so small, that it is going to be using an Access database. This is the code that I am using to generate the Google Sitemap with, however, there is code here that does not translate over to ACCESS Database. SELECT imageid, imagetitle, MedUpdate as DefaultTime, convert(varchar(11),MedUpdate,121) as UModDate, CONVERT(CHAR(8), CONVERT(DATETIME, MedUpdate, 113), 114) AS UMilTime, convert(varchar(11),MedDate,121) as JDate, CONVERT(CHAR(8), CONVERT(DATETIME, MedDate, 113), 114) AS JTime FROM Images GROUP BY imageid, MedUpdate, MedDate, imagetitle order by imageid Could someone please convert this …

Member Avatar
+0 forum 0

I m new to the MS Access, I m prone to the SQL Server Only. Can u plz explain the difference b/w[B][COLOR="Red"] Datasheet View & Design View[/COLOR][/B]. I have some idea,pls check it whether me right pr wrong. In design view,we have to specify by own datatypes & column names. DataSheet View is Create table by entering data. tell me one thing more,where is the Datasheet icon.

Member Avatar
Member Avatar
+0 forum 2

When I was editing the databse, the power went off and now arror comes as "Unrecognized file format ...............". I tried to compact and repair but no success. how to recover data?

Member Avatar
Member Avatar
+0 forum 6

Hi i need a validation rule for MS Access so that only a time can be entered that is between 18:00 and 23:00 The validation rules must allow for the above numbers inclsuively Please Help

Member Avatar
Member Avatar
-1 forum 3

Hi, I am using MS ACCESS. I want to validate a particular field. To check whether if its a valid email address with a @ So anyone have tutorials or website to reccomend or even reply off hand with the expression to check for @ in a string? Thanks alot.

Member Avatar
Member Avatar
+0 forum 8

hi friends! From my Microsoft Access form I would like to hyperlink to a pdf document. At present each record contains a document name and a full file path to where the document is stored. I would like to open adobe Reader and view the specified document. please give me tips regarding this.If possible explain with codes. Thanku in advance. Elanch

Member Avatar
Member Avatar
-1 forum 3

Hi, Have been using the same database for years without any trouble. Suddenly we are getting the Data Type Mismatch in Criteria Expression when we attempt to run a VB function. I am not familiar with VB so much, but have found where the error is happening: [CODE] Private Sub Command1_Click() On Error GoTo Err_Command1_Click Dim i As Integer Dim a As String i = 0 Do Until i > 2 a = InputBox("Please Enter your ClientId" & vbCrLf & vbCrLf & _ " ( which is your surname followed by" & vbCrLf & _ " your security number, eg: …

Member Avatar
Member Avatar
+0 forum 10

In MS Access2007, I want to query ([I]q_Notes[/I]) a table ([I]t_Notes[/I]) in which one of the fields ([I]t_Notes.Topic[/I]) is populated from a Combo Box based on a field in another table ([I]t_Topics.Topic[/I]). I will have a table of several hundred records. I want to use the q_Notes query as the basis for a report showing all the notes posted for any given topic. I've created a form ([I]f_TopicSelect[/I]) that includes an unbound Combo Box ([I]cboTopics[/I]) based on that same table and field ([I]t_Topics.Topic[/I]) as in the t_Notes table that will be queried. When viewed as a stand-alone form, the Combo …

Member Avatar
Member Avatar
+0 forum 8

Hi, I'm writing a database for a computer shop and need some examples to look at. (It's not for a real shop, just a little project of mine) Where Can I find some templates for Access Database templates for a business like this?

Member Avatar
Member Avatar
+0 forum 6

hello :) i'm using MS access as a database of my Windows form application. i'm having problem with create table query, with variable table name. i have tried, but it din't work, as i tried. plz provide an example that can make me understand. suppose, string city = "newyork"; and city should be the name of table in example. Thanks :)

Member Avatar
Member Avatar
+0 forum 3

Hi, I am having problems with deleting part of a record. The record has approximately 15 different fields, and I only wish to delete 3 of them using the following piece of SQL coding: DELETE [PMID 1], [PMName 1], [Price 1] FROM Subscriptions WHERE [Customer ID]="001" The code works absolutely fine, but it just doesn't do what I want it to. Instead of deleting those 3 fields, it deletes the entire row, which isn't very helpful. Any ideas on how to solve this problem? Thanks in advance :)

Member Avatar
Member Avatar
+0 forum 2

hello :) i'm developing an app in VS 2010 C#, linked with an MS Access Database. i want to use a table name as variable. i have tried: [CODE] string tblname = students; string query = "select * from '" + tblname + "' where rollno=123"; [/CODE] but it's not working :( kindly guide me. thanks :)

Member Avatar
Member Avatar
+0 forum 1

hi , i have a textbox control in one sheet and a range of data in another sheet in the same file. how do i copy the range of data in paste it in the textbox control? appreciate a reply thanks

Member Avatar
Member Avatar
+0 forum 12

how to create a short summary form in Access Database? I have created a database in which I have created 4 tables 1. Pregnant Women Data 2. Feedback of Pregnant Women Data 3. Traditional Birth Attendants Data 4. Villages Data I have registered 3397 pregnant women, and issued some women who have 3rd semester pregnancy. and about 247 TBAs also registered. Now I want to create a form in that I want to show the: Total number of Pregnant Women, Total Number of TBAs, Total number of kits issued etc...

Member Avatar
Member Avatar
+0 forum 3

I am creating a shared database to record requests entered by a team of 30. I need to record the Order Number, Reviewer Name, Date, Action Type(Order Type), Client Name, and a comments box for each order entered. When creating forms, Currently Reviewer Name and Date are auto-input so the reviewer will not have to enter this information. Client Name, Action Type are drop down boxes and Order Number is manual input. All are required inputs excepting the comments field. Can 30 people add to one table all at the same time? Or is a more practical approach 30 tables …

Member Avatar
Member Avatar
+0 forum 3

Hello, I am trying to populate a spreadsheet using Access data, however I am having trouble with the line noted below, which is giving a run-time error. I am not familiar with the Excel Object Model, so not sure how the "selection, range, etc" should be used. Any help and guidance would be appreciated: [CODE] Dim xlApp As Excel.Application Dim xlWB As Excel.Workbook Dim xlWBold As Excel.Workbook Set xlApp = New Excel.Application With xlApp .Visible = True Set xlWB = .Workbooks.Open("C:\Users\Public\ABC.xls", , False) Set xlWBold = .Workbooks.Open("C:\Users\Public\DEF.xls", , False) xlWBold.Activate xlApp.Range("B4").Select '***Run-time error '91': Object variable or With block variable …

Member Avatar
Member Avatar
+0 forum 2

I know this might be a very simple one, but yet I can't figure that one out! How do I get data from one table that are not in another? Let's say Table ServerA has: IP, User, Password, Table ServerB has: IP, CanConnect. If ServerA has 20 rows and ServerB has 13 rows. How do I get those 7 rows that are in ServerA but not in ServerB? Here's what I got, but it's not giving me what I want: [ICODE]SELECT ServerA.* FROM ServerA WHERE NOT EXISTS ( SELECT * FROM ServerB WHERE ServerA.IP = ServerB.IP)[/ICODE] [ICODE]SELECT ServerA.* FROM ServerA …

Member Avatar
Member Avatar
+0 forum 2

Hey guys! I have created an Access 2010 database. On one of the tables, there are fields [Start Time], [End Time] and [Total Time]. The user will input the start and end times but and the total time will be the difference between the two. I cannot figure out how to go about this. Any help or direction would be greatly appreciated!!

Member Avatar
Member Avatar
+0 forum 4

Good Morning Lladies and Gentlemen: . I need some help in my app... I am using Access 2007 (from MS Office 2007 Pro). I have an attachment field in my customer table that holds multiple attachments. I need to preserve this data so transferring to from a spreadsheet DOES NOT work... I tried this and the attachment data is lost because Excel can not handle this kind of field. . What I am asking in a nutshell is...[B][I]Code in Access 2007 VBA the ability to send data to another db...[/I][/B] That is what it boils down to. . Say, my …

Member Avatar
Member Avatar
+0 forum 1

how to JOIN three tables in MS ACCESS 2007. the tables are: *student (Primary key: StudentNumber) *event (Primary key: Event_num) *Transaction (Primary key: Transaction_num) the MS ACCESS gives me this code, but nothing appears in the Datasheet view. [CODE] SELECT Student.StudentNumber, Student.Lastname, Student.Firstname, Student.Initial, Event.Event, Event.EventDate, Event.EventFee, Transaction.Status FROM Student INNER JOIN (Event INNER JOIN [Transaction] ON Event.Event_num=Transaction.Event_num) ON (Student.StudentNumber=Transaction.Student_num) AND (Student.StudentNumber=Event.Student_num); [/CODE]

Member Avatar
Member Avatar
+0 forum 1

Dear all, I want to create a page on which I want to display the Number of kits issued, total women visited monthly wise, How much cases are registered total, how much are close due to delivery/migration/miscarriage/abortion/Fake Data. Can any one help me???

Member Avatar
Member Avatar
+0 forum 2

Hey y'all. I'm making a database using MS access 2007. I have a login form from a table which consists of admin and user. I want it admin to enter a different form from the user. Any ideas?

Member Avatar
Member Avatar
+0 forum 1

Hi Looking for some general advice: I have taken over support of a large and complex web site, which uses multiple Access databases. At present it makes use of the MS Jet database engine (Provider=Microsoft.Jet.OLEDB.4.0). (as well as MySQL, used in a Snitz forum). After solving many specific problems I am left with a nasty situation, where certain database calls appear to cause the Jet engine to freeze, and everything halts until pages time out and the blockage is cleared. After such a timeout everything runs nicely until the next incident. These incidents are random. There is some evidence that …

Member Avatar
Member Avatar
+0 forum 3

The End.