1,557 Topics
| |
| 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 … | |
On not filling a text box of a field that is madatory in the database i want to throw a error message to user and set the focus to that particular Text box Please help me in setting focus to that particulat text box. [code]Private Sub Form_Error(DataErr As Integer, Response … | |
hi, in my MS ACCESS front end, when i press TAB to jump to next text box or button focus is shifting in a disorderly way with no proper pattern. What might be the reason. Please help me. Regards Jagadeep | |
All, I have an issues form in a database (MS Daily log) and when you fill in the form it save the data into an issues table. Everytime you do this it gives each issue an ID number (auto number). Basically I want to fill in the form then before … | |
I have a combo box on a sub form. Based on the choice, I want another combo box on the sub-sub form to have a selected choice. I've tried to have the choice change the Row Source on the 2nd combo box but I've been unsuccessful. Both of the combo … | |
For years, I have programmed pretty complex Access databases used by hundreds of end users. I am now tasked with learning FileMaker Pro 9. Can anyone recommend a FileMaker Pro book that would be good for someone who already has database knowledge but would like to transfer skills to FM … | |
I have two tables as below table 1 ProductID---Int Descritption---Text table 2 Id FK_ProductID--Int Category but on the FK_ProductID I dont want my table not to display a number but the description from TBLA. | |
hi there i need to build a basic forum with admin rights through asp.net v-studio , access database. i keep getting mixed up when trying to create the p keys and foreign keys if any one could help me or show me in the right direction i would much appreciate. … | |
My program is using Access mdb database through ADO. I have Access installed here, but there is no Access on that machine which has the database. There is a query, which takes much more time than it should... My question is: - How can I profile that query (under Access … | |
How to add Cristal Reports 9/19/11 Professional into Access 2007 ?? | |
I have a database here that I'm re-building to make it more up to date for my customer. They need a Quote table, form, report, etc. Their quote numbers are generated as "2008-000" 2008 being for the year, and 000 goes as the automated number, for each individual quote. This … |
The End.