1,597 Topics

Member Avatar for
Member Avatar for balls81

I have developed an access database for my company and want this to be available to multiple users remotely from different offices. I have been told that i need to migrate to MS SQL Server. Is this the case?? If so how do i do it? If not what do …

Member Avatar for leo002000
0
255
Member Avatar for pablavo

Hi folks This will be my first ask for help here;) I'm working on a database at the moment and have exhausted my resources on this one. I have a report with an underlying muti-table query. The report uses an input box to set the date criteria rather than Parameter …

Member Avatar for boblarson
0
136
Member Avatar for knoxbillybob

Howdy All! Here's what I have and what I'm trying to accomplish. I have four reports in access that I run once a month. The reports are designed to hit on a query that pulls the records needed for a specific client based on the previous calendar month. Basically, each …

Member Avatar for boblarson
0
92
Member Avatar for pikkas

there a way to get this info about my tables in a text file or anything that can be copy paste . i have many tables so i cant write them one by one? Properties DateCreated: 08/05/2007 11:38:58 PM DefaultView: Datasheet GUID: {guid {A79F9FC7-D630- LastUpdated: 09/05/2007 12:18:31 AM 47FB-A227-EB5202999268}} NameMap: …

Member Avatar for K7AAY
0
123
Member Avatar for CAInc

Goodday all, Just tried to install MSDE, no sooner then i click the intall icon, i get this message "A strong SA password is required for security reasons. Please use SAPWD switch to supply the same. Refer to readme for more details. Setup will now exit." Now i took a …

Member Avatar for jazzydancer
0
539
Member Avatar for rajaboys
Member Avatar for jonc
0
120
Member Avatar for peterrobertson

Is there a way to open the main access switchboard in windows without showing the access program? as a usable Data Base.

Member Avatar for peterrobertson
0
165
Member Avatar for JGinside

Okay, this is the situation. We are trying to set up a database where we input individuals for their personnel evaluations. We created a button in the form window and linked it to a macro that updates the "Date Due" block based on the date in the "Date Completed" block …

Member Avatar for jbennet
0
102
Member Avatar for N!ck

I would like to append bookings in a database that are older than 2 weeks old, what is the criteria to do this please? thanks

Member Avatar for juustout
0
49
Member Avatar for pramodakumara

i wanted to restrict the national holidays in validation rule (msaccess),i could restict one holiday ex:-15-aug every year by applying ([hdate])<>15 and month([hdate])<>"aug" but when i tried to enter two holidays ex:-([hdate])<>15 and month([hdate])<>"aug" AND([hdate])<>26 and month([hdate])<>"jan",it did not work.Help please. pramoda

Member Avatar for Sulley's Boo
0
86
Member Avatar for Grantmitch1

Hello Daniweb Community, I wish to use a microsoft access database for my website. I want it to do the following: 1. work as a login script 2. work as the points script I wish for users to log in using microsoft access - can I get a script for …

Member Avatar for Grantmitch1
0
83
Member Avatar for hhaannyy
Member Avatar for Alekhan

Hello, hope all people around will be fine and enjoying programming. I want to do get data from the database which is available on internet domain while my application is window base application. Is there any complete method i can get data from the database.

Member Avatar for Alekhan
0
162
Member Avatar for Pareshja

Hi Guys, I need your help. I have created an Acccess application using forms to view, update and delete data. Is it possible when I delete a record using a button on a form, that the record is deleted from the table and goes into a temp table where I …

Member Avatar for kramero
0
98
Member Avatar for CezzaXV

Hi guys, I'm in a real spot of bother and this is really beginning to get me down. Basically, I need to program a class which will connect to a MSAccess database. I'm using Visual Studio 2005 and C#. I'm really at a loss for what to do. I've looked …

Member Avatar for CezzaXV
0
86
Member Avatar for icantdoaccess

how can i make an error message appear for a input mask i have an input mask that allows only 3 digets to be entered, but i want to show a message if someone enters this in wrong, how can i do so?

Member Avatar for kb.net
0
60
Member Avatar for peterv200

I have a control in an access database that holds credit card numbers. I want to format the control so that it only displays the last 4 digits the first 12 digits just displaying an X so that it will appear like this XXXX XXXX XXXX 1245 What is the …

Member Avatar for kb.net
0
62
Member Avatar for hinzyk

I have a query to find dates based on Between And criteria but I can't pull up anything in 2008. all 2007 dates work properly. What am I missing? Thanks

0
133
Member Avatar for djbsabkcb

I was wondering is there anyway to wrap the text in the columns? Also, is there a way to adjust the column width automatically? I know how to do it manually, just wondering if it would adjust on its own. :?:

Member Avatar for GolferGuy
0
118
Member Avatar for Doonie

Folks, Many years ago I worked as a dBase III programmer. In my early 30's I left the field of IT to persue another career. Today I am required to develop databases for a variety of stand-alone (PC) applications. I have Access to construct the database but I need advice …

Member Avatar for CertGuard
0
87
Member Avatar for EnderX

I have been working on a program designed to read information from an Access database and display it on the screen. As my main development box doesn't have a copy of Access on it, I copied the data over to a PostgreSQL database and attempted to work from that. Now, …

Member Avatar for CertGuard
0
108
Member Avatar for TenKen

Hello to all. I saw a post about multiple imports from a folder into Filemaker. I plan to give it a try soon. What I am curious about is there a way to Filemaker automatically import the files from a folder. This could be a once a day or once …

0
58
Member Avatar for yang1302
Member Avatar for rockygoodness
0
101
Member Avatar for ddezwart

I am using SQL to write to an MS Access db via JDBC. Whenever the word or word-portion "update" occurs within a text string I am trying to store, I get an error message that "update" is a reserved word, even though it has been correctly delimited (such as 'xxx …

0
59
Member Avatar for andhaller

I have recently updated from Office XP Developper to Office Professional 2007. Although I have navigated a lot in the "Help" documentation of ACCESS 2007, I could not find any instruction about how to join a Workgroup (xxx.mdw) used by my protected ACCESS 2002 Databases. Therefore I cannot open them. …

0
63
Member Avatar for petalito

Using FileMaker Pro 8 I have a table whit a column for dates, like showing below. dates Mon, Sept 10, 2007 Wed, Sept 12, 2007 Wed, Sept 19, 2007 Mon, Oct 8, 2007 Mon, Oct 15, 2007 I want a field(s) to show all those records like this Sept 10, …

Member Avatar for laurenkuhlman
0
101
Member Avatar for greeny_1984

hi every one, i have an application in which i have to send email alerts to a student untill he pays his feez.we are using windows 2000 professional and outlook 2003,msaccess 2003.Iam new to using msaccess,can anyone give the detailed procedure on how to send automated emails using macros or …

Member Avatar for greeny_1984
-1
194
Member Avatar for packpower8

I just found an easiest way to save your documents. It can then process this data as well to create quite complex filing systems.[URL="http://www.awgarstone.com/product.php?item=activefiler"]Activefiler [/URL]could be easeasily be used from any Office program, or any program that can call a DLL as it exposes a full API.You will need to …

0
84
Member Avatar for cutterman

How is the best way to back up Outlook 2003 Contacts. I want an external back up that I can transfer contacts to another computer and do it daily if need be.

Member Avatar for Evaldas
0
152
Member Avatar for kshrini

Hi All, I'm developing an application using VB 6.0 & using MS Access 2000 as backend. How many records can I store in a table? Is there any such limit?

Member Avatar for kshrini
0
132

The End.