1,597 Topics
 | |
| | 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, … |
| | Hi, im new hear and at access programming for a ear now. I'm looking for ways to improve response time on or access CRM here inwork. Currently we have a frontend(forms and queries) and a backend(tables) stored on the file server, the users here(about 25) use access on terminal server. … |
| | We have an MS-Access DB that we would like to create emails from is that possible. Approx. 140 employees we like to create emails to from Access. Thanks for any pointers. Russ @ scaninc.org |
 | I have 2 tables: Match and Team. Match(matchID is primary key, team1, team2, ...) Team(TeamID is primary key, ...) I mean how to force team1 and team2 is different from each other. Ex: We won't want to see: Brazil vs Brazil ^^ Any help is appreciated... |
| | HI, I am a beginner. I have designed a simple site in HTML. I want to add a login and register page. And I want to add a database to store the login and register informations. Can anyone help me with this? I am beginner in database. |
| | I'm trying to make a log in page in Dreamweaver that can pull and store information to/from an Access database that I have in the web folder. [I]If someone could walk me through this that would be the best thing ever![/I] I've tried using ASP/Javascript as the Document Type (not … |
| | how to convert the file format of access .mdb to .dll system? can anyone know? |
| | HI all, Very urgent. I am building a Access DB and i would like to autipopulate a specific Outlook Form that resides in : tools/forms/choose form: " name of the form". Is there a way to autopopulate this outlook forms ? thanks M. |
| | I am trying to write a script (which i have done) that sends a meeting request out from Access to users outlook. When they accept it adds that meeting to their outlook. But if a user declines it deletes that meeting out of everybodys outlook. e.g. if I send a … |
| | Hello Again, Again being a novice at MS Acces 2003 this is definitely outside my ability. I was told that using visual basic it is possible to show a month calender in a form instead of just entering the date in a field. The user should be able to have … |
| | Good afternoon and Jose and Murdo here with our MS Access database fun for Christmas! What we'd like to know is there an easy way to find out which of our employees are here for the 25th December and the only data we have is linked to our Leave Status … |
| | Good day everyone and are there any Access geniuses out there who can help Jose and myself with some links, dates and logic for our HR database that we are stuck with? Cheers, Murdo PS My ady is <EMAIL SNIPPE> |
| | Hi, Please help me with Expression builder for my FOrm. Weight_likely - back end DB Column I want an expression, where if Weight_likely is blank then in form 0 should be populated or if Weight_likely has a value then the value itself should be populated. =IIf([Weight_likely]="",0,[Weight_likely]) Please help me on … |
| | Hi all, I have this sql line (below) and where it works fine at the moment. But I have columns with 2 words i.e. opened by. I would like to add this colum to the statement below but everytime i try it errors. Do I have to reword the statement … |
| | I have a busted five table design for a food item guest ticket . Here are the names(Actual) of those tables: GuestTicketType, GuestTicket, GuestTicketOrderCategory, GuestTicketOrder & GuestTicketPayment. The incomplete(busted) design looks like this: guesttickettype has a field named guesttype, which is one of three guest types: dinein, takeout, delivery. The … |
| | Hi, anyone can help me convert or set my .mdb with form in ms access file to an application? i mean an application open the interface(form) without open microsoft access. |
| | I am writing my first database app (windows form in c#) and I am using an access database. I have 2 tables with the following fields: payroll --Store --lastName --PayFreq --SSN (PK) --HireDate --EffectiveDate --TermDate --DeductionCode --Deduction --NAD CHAR hrconnection --Store --lastName --CoTime --Plan --Dependants --HireDate --EffectiveDate --TermDate --SSN (PK) … |
| | I have given below a code snippet where i am able to generate a ppt with one slide. In a loop the followig code snippet will be passed with new "dbId" and for each "dbId" new slide has to be added in the already existing PPT as extra slides. Please … |
| | I'll start off saying I am not a programmer. I am making a database that imports data from Word forms. It requires code and I found some that works almost perfectly for me at [url]http://msdn.microsoft.com/en-us/library/aa155434(office.10).aspx[/url] It does exactly what I need. The only thing that would make this code better … |
| | Dear Sir, I have developed the database program for storing the Company bills. it has two table COMPANY & COMPANYBILL. It has 1-Many relationship. In the COMPANYBILL table i am storing the BillAmount and PaidAmount. Also i have create a form for the COMPANYBILL. The Report shows the BillAmount, PaidAmount … |
 | I made a querie with 2 table. both of 2 table have date fields. the querie also have this both of date fields with other fields. so all data show in a each line. like name | address | date this 3 fields in table1 Roll | Class | date …  |
The End.