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 …

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

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

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 …

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 …

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 …

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.

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.

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

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: …

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 …

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?

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 :)

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 :)

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...

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 …

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 …

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 …

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!!

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 …

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???

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 …