1,557 Topics
 | |
| | 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 … |
| | Hi, I know many people have asked similar questions but I wasn't able to search for a direct answer. Much like the other questions I'm looking into creating a web page that will allow users to edit/display information saved in a MS access database. For some reason, users have difficulty … |
| | I have safari, explorer, and firefox and none of these browsers can connect to these sites. I use Noton as an anti virus and zonealarm as a firewall. All of these problems started when my Norton subscription ran out. I went to the norton site to renew it and i … |
| | Okay so I have been trying to get this program to work for a long time. Basically it reads a text file then populates a structure that is designed to point to the four locations around that object: up, down, left and right. I believe I have the program figured … |
 | Hi, so as I said in a post a couple weeks ago, I am doing a project for my school and I am having some problems at the moment. My problems include, get values from one tab to another in my form and get values from one form to another. … |
| | I have created a Database with some related tables say Customer and order and they are joined with the CustID i have created the main form and the subform and linked them together. My problem is if i say put in the key where they are joined for the 1st …  |
| | setting a keyID in new form, then setting image related to keyID - Null problem Hi I am stuck - I am opening a new (child) form in Add mode Setting this childID, from the parentID from previous form Setting childID back to parent form for later reference. Once the … |
| | |
| | I'm relatively new to access and have a problem. I have multiple rows of information on a form, and each of these rows has a few text boxes and one combo box. The combo box needs to have different information in it based on another field in the row. The … |
| | Hi All I am trying to query my access DB using a C# windows app and one of the fields is a type date/time. I have set the field to general date but when i run this query it displays the date and time set to 00:00:00. How can i … |
The End.