[microsoft-access] Forum Topics

I'm in the planning stages of an inventory db. The part I can't figure out is how to design the database as far as changing costs go. If I have a cost associated with an item, how do I handle when the cost changes? I know I need to have …

Ok, slight problem. I have a reservation with rooms. I need a query which will look at the "Arrival Date" and "Departure Date" So the query basically tells me which rooms are available from that. I would also like to no how to actually send emails from MS Access? Thanks

I have an issue wherein the number of fields(columns) in a table exceed 255 in MS Access.ie(370) So i decided to split the tables into 2 diferent table each containing 185 fields. Then before running the QTP script, I join the 2 tables and store them as a view. View …

Dear Friends, I am designing a database for a local garage where they repair and sale cars. I have come up with the attached normalisation. I would be very grateful if someone could have a look at it and give me some feedback on it. Kind Regards HB25

I am having a problem wit searching my database when i click search it says syntax error with FROM Clause. Here is my code n screen shot! Its the code for the find button!! [code]Option Explicit On Public Class Form1 Private Sub DisplaySearchResults(ByVal objectname As String, ByVal FieldName As String, …

Hello, I spent hours wondering why this statement doesn`t work. I would like to insert record in a table if it doesn`t exist already.If record exists then a message will come out saying record exists. The values for the record to be inserted are current selection in combos on a …

All, Have a form with over 189 controls on it and trying to automate the save. I currently use the following script to init the fields: [code] On Error GoTo Err_Msg For Each ctl In Targetform.Controls ' 100 = Label, 106 = CheckBox, 109 = TextBox, 111 = ComboBox Select …

Hi, I would like to query from you people if its possible to change back color either row wise or CELL wise in List box. Also I would like to know any other ways of listing record in forms other than in List box, Flex Grid and Data grid. Regards, …

just wanted to know how i can input a search facility to my webpage, which is on short courses. i want it to retrieve information from my database to display on my web page. my webpage is linked to an MS Access database. if anyone could help me u would …

* [B]Edit:[/B] Sorry about double negative on the title, I don't know how to edit it back First of all, I am fairly new to Microsoft Access VBA. I created a form with 2 textbox (txtUsername and txtPassword) and one label act as button (I use label instead of button …

I'm working through the lessons at Programmer’s Heaven's "C# School" tutorial ([url]http://www.programmersheaven.com/2/Les_CSharp_0)[/url], and I'm currently on lesson 13, "Data Access in .Net using ADO.Net", so of course I've been trying to connect to Programmer’s Heaven's SQL and MS Access / OleDb databases. Unfortunately, they're now offline. Can anyone please tell …

Hello there! I developing a database simple enough for my friends to use using ACCESS. I wanted it to be only one Table only. The fields I want to play with are: TrackID, Member_Lastname, Member_Firstname, IDcolor, IDnumber, ReferredPerson_Lastname, ReferredPerson_Firstname, RPIDcolor, RPIDNumber. I created a dropdown combo for each on the …

This seems like it should be an easy one to answer, but I remain clueless after many days of searching and trying different fixes. Basically I have a report with many sub reports, such as a form that shows family information and insurance beneficiaries, which all have their own subreport …

Basically I have made a database that does all of my company's human resources needs. Now I have no training and everything has been learned from trial and error and/or looking up on the internet, but try as I might, I cannot find the answer to this question. Basically on …

Hello all, I am having a bit of an issue with a report / query I'm running through a form. Thanks to your wonderful forums I have figured out how to take a value from a combo-box in a form, and run it to a report, however, when it does …

Hi, I am creating a survey where 2000 people people will attend. I use Ms Access 2003 as a database. Do you think, Access is capable to do this? I am wondering, if more than one person use Ms Access, will it be still safe. Thanks

Hi, I have 2 questions for concurrent access to a TXT file and Ms Access. I have a TXT file to store user entries (Name and Surname). I also use Ms Access Database to do same thing, storing user entries. If more than 1 user uses my service, will it …

Hello everyone! Would like to seek help from experts. How can I make a "command button" in MS Access 2003 that will automatically convert "a record" (in a form view) to a PDF file? Will it be done using a code builder? Please help me..tried many times but it all …

All, Trying to get a date WHERE statement to run to pull all records for the month. What I have is: [code] Dim SQL_Str, DatStr, MonVal MonVal = Get_Month(TargetForm![cboxMON]) DatStr = MonVal & "/*/" & TargetForm![cboxYER] SQL_Str = "SELECT * FROM qryREPrev WHERE ([tim_ted]= like #" & DatStr & "#)" …

Hello, My first post and I am hoping someone can resolve this strange dilemma. I am creating a text file by exporting the results of a query. One of the fields is a phone number that is formatted 999.999.9999 Unfortunately not all exported phone numbers are correctly formatted in the …

Dear all, Thanks for keeping this wonderful forum going. I am having a problem with my application which I have developed using MS Access. I have a form which I use to enter workorder information which is not bound to the workorder table, I am using VBA t save data …

Hi, I recently got a project where i have to make a simple access database and a webpage which serves as a form to enter data to the database. I dont have experience with web design but i have some experience with access. Would anyone know any good books to …

hey all, I am developing application which has a huge data base. From that application, I generate REPORTS in Excel and FORMS(MS ACCESS) and also some PIE and BAR graphs in MS ACCESS file itself by linking to MS ACCESS back end. Now , I am wondering if i could …

I have column table which has values 1 and 2. What should i code in CRITERIA of query builder so that when checkbox is ticked in form all records in the table with column value 1 appear and records with value 2 appeas if unchecked. path for check box: [Forms]![frm_Main]![opt_prr]

how do you connect 2 access database files(mdb) and have the 1st one as the form and the 2nd one as the database and if you you the 1st mdb with the forms the database will be opened and showed in the same file? anyone who has an ide on …

Hello. This is my first post. I have a problem, it goes like this: I have a Table named "Documents". Each document has a category and a sub-category. I also have a table named "Categories" and another one called "Sub-Categories". The categories table has 2 columns: 1)Id 2)Category name. The …

I am sorry to take the liberty to email you directly, but I am in a really tight situation that I cannot seem to figure out. I am creating a database in MS Access. I have created several tables that I would like to link with each other. I created …

Hi! A bit of a stuck-up. I have a problem which is probably simple to manage (not for me though - my brains work 24hrs/day and don’t come up with nothing). I want to show several different values from one field (in query) on the report - now check this …

If anyone can point me in the right direction I would greatly appreciate it. I am making an Asset Management database. I'm looking at having about 50 fields in a table. Of those 50, 25 could potentially be used for searching. In some cases multiple fields would be used to …

All, I'm writing a script/function to automated putting buttons on the screen. I'm running into a problem with var substitutions in my strings, which is necessary to make it run. Here is my code: [code]Function Get_Btn(MyForm) Dim Wspace As DAO.Workspace, dbs As DAO.Database, rsDEST As DAO.Recordset Dim SQLstmt As String, …