1,557 Topics
 | |
| | I was wondering what all files this program accesses, and any other info you could tell me about this program.. The program is in the link below. [url]www.thelandofoz.net/help/program.rar[/url] Mucho thanks in advance!! -DaJ4ck3L  |
| | hey, I have a table say 'Student' and it has the regular fields and a PK called 'stNo'. I ahve made a form to view/enter data for this. This is what I want it to do. When you enter a value into "stNo" if its not present in the table … |
| | Hi, I know this sounds like a repeated question but the tips in other threads didnt quite help me, so thought of asking again. I have 2 tables 'tbl_AWB' abd 'tbl_flight'. Flight has the fields "FlgihtNo" (PK), "DepCityPort","DestCityPort", "DepTime", "ArrTime". tbl_AWB has fields 'FlightNo', 'DepCity' and 'DestCity'. The tbl_AWB is … |
| | I didn't find any place to search to see if my question has been asked already. I am a student taking MS Access 2007. I created a report in layout view. I need to use conditional formatting but it is grayed out.Can some help me so I can use conditional … |
| | I would like to add code to open the form to the on click event of an unbound OLE object. I know I can easily make a button to open the form and place it in the form , I just thought it would be nice to use this shape, … |
| | [COLOR="Green"]Hi, forums I'm not much familiar at access(and English too). And pleases give me the VBA code and needed property settings to my OLE unbounded object control( step by step). 1. my access version is 2007 2. database file name is 'tense db'. 3. i created my OLE unbounded control- … |
| | [code=sql]Select * from Merit where cat='GEN' order by snum[/code] in this querry, i hav a problem as "No value given or required paramenter" due to snum fiels the Datatype of snum is Numeric |
| | Hello Every one! i'm trying to encrypt my ms access database using the encrypt tool in ms access2003. After i encrypt it, i want to decrypt it, using visual basic so that i could run my visual basic forms. Can somebody help me how to do it? Thank you very … |
| | Hi, I have created a data entry user form in MS Access 2007 which pulls out and puts in data from/in 3 different tables, When I create a new form(a new record should be created in all 3 forms with my primary key), I can enter data in fields from … |
 | I made this program during forum discussion for accessing configuration relative to module directory, not main program's position (which can be accessed by sys.argv[0]'s directoryname). As the thread is closed I post my proves as code snippet. |
| | I have a web application that links to Microsoft Access and opens one of five databases depending on which button is clicked. I coded it on my machine in Visual Web Developer 2008 and it works exactly as expected when ran on my machine, but when I move the files …  |
| | I have a database using Access 2003 for the front end and MySQL to store and process all the online queries for the website. Several of the queries I run on the database are done daily as part of creating the data tables to support the site. Some of these … |
| | I have an application that uses an *.accdb file as the back-end database. Connecting to and retrieving data from the access file is not an issue and is working quite well. However, as a precaution, I have the application first check to make sure the database file exists in the … |
| | Hi I have designed a database for use in an academic arena, but I have come across a problem that I can't find an answer to in the help files or on the web. I think it is something really simple but frustrating to put right! I have designed a … |
 | Hi there. how can i limit the value of records in Access. Is there a LIMIT function in Access like in MySQL? tnx in advance.. |
| | ok,i accidentally plugged my usb(accessible) out because i'm in rush..after few hours,i plugged back again, nothing happened...i mean,NO AUTOPLAY,NO ACCESS unlike before. I can't see any drive in My Computer.when i go to Device Manager>USB controllers...there is one icon there with a "yellow !"..thinking it's my usb, i always tried … |
| | I know that i might be jumping straight into the 'deep end', however I want to make a program which accesses a file (.txt for example) over the network. For example, you type in the IP Address of the computer where the file is stored, and the program reads from … |
| | I'm having problems trying to create a database in MS Access, to do receiving and dispatching of goods. I need to create a database for a cross shipment depot,there are three points of interest. Goods Received. Which do not always have are not standard Products that I can create a … |
 | Hey all. I'm trying to write a query that gets all the multi-field data from a record in another table it has a relationship with. I'm using MS Access 2007 and would prefer to have it written in a SQL query. Here's an example of what I'm trying to do: … |
| | Hi, I'm trying to build an Access database on Access 2007 and I'm unsure of how to do a few things. I have 2 fields: field1 and field2. Both are dates. I want field2 to change to exactly a month after the date in field1 and I want it to …  |
| | I have been regularly logging on to local library's public wi-fi network with 2 different laptops. After connecting to the network, any attempt to load a Web page brought up the library's portal, which requires users to agree to terms & conditions, upon which normal Web access is granted. Today … |
| | I have recently made a database in MS Access that has a user-friendly GUI. Can someone please tell me how I can hide the Host Application [MS Access] so that when I run my database, the GUI gives the illusion that the database that I created is a stand alone … |
| | Hello I work in an accounts office where we have a filemaker pro database for all our contacts. We are having a new server and I'm wondering if the filemaker pro database would still operate with the new server. Would it still be compatible? |
| | I need to calculate the difference between 2 Dates in Days according to the DayCount Rule 30/360 In Excel it is easy =Days360(StartDate, EndDate,1) 30/360 = every month = 30 days, the year =360 In MS-Access no problem as well, just in Filemaker I can not find a solution for … |
| | I have MS Office Pro on a work computer that we just tasked to a new job that requires MS Access. All of the other programs in MS Office open and work fine, but when I try to open Access (either by clicking directly on a file or by just … |
| | I am currently trying to create a live search box that as I type it will start displaying results that match. Here is an example [URL="http://www.w3schools.com/php/php_ajax_livesearch.asp?output=print"]http://www.w3schools.com/php/php_ajax_livesearch.asp?output=print[/URL] but it retrieves its data from an XML file, I need mine to retrieve from a column called FirstName within a table of an …  |
| | This is a logic question (or at least I think it is). What happens when the select term and group by term do not match? Why? The sample code is here: [CODE] SELECT [B]Name[/B], max(Age) FROM People GROUP BY [B]Name[/B][/CODE] So what happens if those two bolded field names do … |
| | I have created a database for a hotel booking & billing system, can't seem to stop from booking same room on sdame dates. Have indexed so that can't book in on the same day, but can still book the next day. Any clues? |
| | I"m new to this site so i"m not sure is this question has been answered before but i"ll ask it anyways. i have a simple small access database and i need to create a link between it and our website but i'm not sure how to go about it. what … |
| | Hello everyone! I am using python 2.6 on cygwin environment and wondering how could i prevent two python processes from writing to a file at the same time. The file that is shared between the python processes is an ini file and is accessed through ConfigObj module. The first python … |
The End.