1,557 Topics

Member Avatar for
Member Avatar for MarcusMaximus

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

0
50
Member Avatar for TechExpressInc

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

Member Avatar for freshfitz
0
181
Member Avatar for Emerald214

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

Member Avatar for jbennet
0
59
Member Avatar for lavin

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.

Member Avatar for boblarson
0
109
Member Avatar for digits

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 …

Member Avatar for faikdjikic
0
103
Member Avatar for ryan311

how to convert the file format of access .mdb to .dll system? can anyone know?

Member Avatar for boblarson
0
62
Member Avatar for korssane

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.

0
58
Member Avatar for Swarv

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 …

0
54
Member Avatar for dstat

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 …

Member Avatar for Swarv
0
83
Member Avatar for murdoduncan

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 …

Member Avatar for timothybard
0
99
Member Avatar for murdoduncan

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>

Member Avatar for murdoduncan
0
175
Member Avatar for dinilkarun

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 …

Member Avatar for HI2Japan
0
124
Member Avatar for Swarv

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 …

Member Avatar for Swarv
0
94
Member Avatar for mikeistyke

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 …

Member Avatar for timothybard
0
254
Member Avatar for denniskhor

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.

Member Avatar for ac001
0
2K
Member Avatar for Shuco

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

Member Avatar for Shuco
0
109
Member Avatar for dinilkarun

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 …

0
71
Member Avatar for HI2Japan

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 …

Member Avatar for HI2Japan
0
171
Member Avatar for Fawad0301

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 …

Member Avatar for timothybard
0
85
Member Avatar for abu taher

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 …

Member Avatar for kb.net
0
87
Member Avatar for dinilkarun

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 …

Member Avatar for kb.net
0
104
Member Avatar for dinilkarun

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

Member Avatar for timothybard
0
80
Member Avatar for Swarv

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 …

Member Avatar for Swarv
0
134
Member Avatar for Papaof3

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 …

Member Avatar for boblarson
0
79
Member Avatar for penningtonTech

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 …

Member Avatar for dwikstrom
0
96
Member Avatar for Sally123

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.

Member Avatar for Sally123
0
79
Member Avatar for davidcrossan

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

0
65
Member Avatar for MoZo1

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 …

0
74
Member Avatar for wernerfreber
0
59
Member Avatar for ITMeister

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 …

Member Avatar for ITMeister
0
140

The End.