1,597 Topics
 | |
| | 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 … |
| | Dear All, I need help in writing a query and would appreciate any solution that would solve my problem :) Some background information: I have a table which records the price of a commodity at a given date and time (5 minute increment to be exact). The first column represents … |
| | if not exists (select * from sysobjects where name='amrreconAccountsTB') begin execute "create amrreconAccountsTB(acct_id char(2048) NULL)" end; Message from server 'NOCTREPI04' (Msg 156, Severity 15, State 2): error near the keyword 'end'. Can someone please help me and tell me what is the syntax error here? |
 | Hi all, Did a site for a group I belong to. Now they want me to add a login page that would take people to a members only area. Need to be able to validate the users via a database. The only database I have available to me is Access …  |
 | I've created a game and want to record highscores through textboxes. I've thought using an Access database may be one idea but seems quite complicated at my level of programming. I'm looking for some ideas or an alternative to using access. If not then some way i could go about …  |
| | I want to write a complex piece of coding that will do several things: 1) It will clear the contents of a folder named "Cache". 2) It will open (if not already) Mozilla Thunderbird. 3) It will find the latest email that starts with a specific title. 4) It will …  |
| | Hi, I would like to know how to put a small access database online and make it password protected. When accessed I would like the people concerned to be able to edit it and add information. Please can you tell me how and if this can be done. thanks richard |
| | I'm using an access database to save plain textboxes. I've made a connection with the database. Now i need to find the code to add the textboxes to my database. I've tried to add with the bindingnavigator but it won't work... please help... |
| | I have been given a report that is generated by running the following query from a macro ( slightly edited to simplify )and I have not had a great deal of experience with Access. The report is grouped by Data.Type and sorted be Data.Date [ICODE][COLOR="Green"] SELECT DISTINCTROW Data.Type, Data.Date, Data.Code, … |
| | I am working on updating a database where some measurements are stored as text. The updates I'm making are to let the engineers that use it convert their measurements into different units. Long story short, the numbers must be kept as text for a couple reasons that I won't go …  |
| | [B]How to add and / or delete files to modify a program's installation?[/B] Hello all, this is my first post and to be honest, it doesn't really seem like this is the ideal forum to ask such a question, however I can't find a more relevent forum. Therefore if this … |
| | What if you dont want to clear all the records in a table, maybe a few columns of the table, how do you do that? and secondly can you please give me steps on how to assign a macro to a button. |
| | Hello, U just started using acces and I need to make a query using multiple tables. I read some tutorials and watched videos but I can't seem to do it right. I have 2 tables: the first one is Login, the second one is Group. Login contains Username, Name, Group … |
 | Hi All, I think this is my first question here. My web application uses an Access database and I'm getting some strange behaviour which might be related to that. Here's the issue: At the end of processing a users request (during which a lot of calculations are done), a record … |
 | Dear Member, I have made my project through MS Access 2007 with a form. I would like to publish that form and database on web as it is so that i may assess it any where. Your prompt response is required. Best Regards, |
| | So I have a database (for tracking customer applications through to approval etc.) in MS Access form & and all (but access just isnt the best way to do this for many reasons I wont get into). I have looked at lots of programming language and decide that VB was …  |
| | Hi I have a database with many staff members and each staff member has many Customers assigned to them. I want to export customer details to a separate excel file for each staff member. I don't want to have to do this manually as its going to take up time. … |
| | hi i am a new access user and i have been asked to create a database for students in our college. well i never knew i would need to to alot of work but clearly i can barely start. i need to put student details i.e name, age , class, … |
| | I have created a table named "MapDetail" : the FIELDS identify the formname, the name of the textbox , and data to be transferred to that textbox. My form contains a map of city lots. Each of these lots contain a Textbox. My objective is to load each Textbox with … |
| | Hello everyone, I’m an intermediate-level C++ programmer grappling with a fairly rudimentary problem. I’m creating a C++ object called FruitCart; FruitCart contains a number of integers categorizing the numbers of individual fruit in the cart. I also need FruitCart to contain accessor functions so other functions can set, retrieve, and … |
| | The program is an inventory control that is suppose maintain store merchandise details in random access files for 3 store locations each location saved to its own RAF. It also uses multiple forms for user to add merchandise, edit/view merchandise details and display an inventory report. Everything is working in … |
| | Hi everyone, I'm working on a Video Rental system in VB that needs to be binded with tables of information in MS Access. I have 4 tables (Employees, Members, Stock and Rentals) that need relationships with each other. I need to draw information from fields in 'Members' and 'Stock' so … |
The End.