3,842 Topics
 | |
| | I want to get list of top 10 students (based on marks) in class.How can I write SQL query for it? |
| | Hello, I am using TransferText to bring a text file into an Access table. Is there a way to turn off the Import Error file that is produced as a result of improperly formatted text? Thanks! Mark |
| | Hello, Can anyone help me add a column to my Access table? I would like the column to be populated with a number that iterates from 1 to the end of the file. Thanks for your help! Mark |
| | I am trying to import several files to access. I have the code to search the C:\ drive but I need to look thru all the folders also. Below is what I have so far the works. Thanks in advance for any help. Wayne [code] Dim strfile1 As String Dim … |
| | Im looking for a good access VBA book. Im advanced in access but completely new to VBA but have done other programming languages like c, c++, java, php and a few others Any recommendations greatly appreciated Thanks |
| | I am trying to crate a web application for a database (a form and a search+results pages). HOWEVER, I am seriously stuck because I cannot install IIS on my workstation to start working. The university I am at cannot have me IIS installed (it's forbidden) because it would turn my … |
 | How can you make a table from a union query in access - i have the union working and producing what i want but i can store it as a view or as a table - i keep getting syntax errors [code] INSERT INTO HgTotals SELECT CollectionDate,HgTotalnglA as AllHGtotal FROM … |
| | Hey guys, I'm new here and actually new to access 2003. I have deal with Vb.net but never access. I actually doing a intern and they want me to build a huge database. All there documents are spread out and all over the place as format of excel. I could … |
| | Hi I like to know haw doI create a form based on multiple tables, all tables are linked. Some table contains drop down lists, I want all info in all tables dispalyed in the form. Help Please |
| | I created a form in Access. I would like to put up the form on our website so people can enter their information. We need to review the data before they get into our database. I am actually stuck about how to publish the form. I thought it was an … |
| | Does anybody know how to extract a link from an OLE embedded link in Access 2000? I have a DB where instead of a hyperlink there is an OLE object, linked to a Word file. I want to easily see what the link is, without actually clicking on the OLE … |
| | Good afternoon, Can a runtime environment connect to and update records in a FM database on a file server? From what I understand, runtime env's package a copy of the actual database and allows someone to use it on a system without FM installed.... Basically, I want to create a … |
| | OS: Win XP Pro Apps: FMPro 9 and MS ACCESS 2007 Database Types: both are Local to my machine Good afternoon everyone!!! --------"Connect to a MS Access DB"---------- I am new at using FMPro 9 (very new after a year of using VBA to manipulate and control MSACCESS db's)... I … |
| | Hi, I have created an Access 2003 database for about 20 users over a network. I am currently weighing options as to just have the database on the network or to split it. The one main question I have is how to distribute design changes and possibly table design changes … |
| | Hi all, I have a problem with a query in access that I cant seem to figure out. I have a form named frmRecruitment with a subform named sfrmParticipant. At the moment I am using an append query to append records from 'sfrmParticipant' to 'frmIntervention' using a button on a … |
 | Hi, All Need a little help. I have a client that is getting this error while working in MS Access. There is a database that is housed on a network drive. There are 3-4 users at a time working on 1 table. The database was created about 5 years ago … |
| | I would like to have a form where it automaticlly filled with reports as I build each report. Is there a way to do this? Thanks for any help. |
| | Hi All, I got a question regarding sql. I got some data in a ms access. There's 3 columns, namely id, name and address. Here's an example. [CODE]id name address 1 a c 2 c d 3 d e . . . . 100[/CODE] And, I need to insert a …  |
| | I was wondering if anyone out could help me with a problem I'm having. I have been asked at my job to set up a purchase order database and one of hte things they want is when a purchase order form is filled out, instead of the data going into … |
| | Hi All, I apologias to everyone posting all these questions. I have a meeting on Monday afternoon to review the possibility of using FileMaker pro 9 as our database. Having said that, I need to setup a database in FMPRO 9 and present it as prototype for that meeting. So … |
| | I am trying to develop a website for a babe ruth baseball team. I want to include a page that displays team and player statistics. I have created Excel files for data from each game. I have also created an Excel file that collects data from each game and adds … |
| | Hi, I would like to know if there is a way to link to a sql table, but not be able to edit it, the table is part of another program data and I just want to look at data, maybe copy to spreadsheet. I figured out how to get … |
| | Dear Friends I am relatively new to Microsoft Access and I have to create a report to perform below task, any suggestion, comment and advice will be really appreciated. Task 1: Prepare an order as a report (similar to the attached order form) to show an order for a customer … |
| | I am quite comfortable with MS Access and have developed a complex relational database for my company. However, we have decided to use FileMaker 9 as our database development software, so I have been asked to re-create this same databse in Filemaker. I am finding it difficult, as the simple … |
| | I am new to FileMaker Pro 9 and have used MS Access a little. I am wondering if it is possible to transfer files from FileMaker Pro 9 (many files) to a web MS ACCESS database where another company where we send our data? |
| | Ok so i have an interesting problem i need some help with. I am a beginner/intermediate user of FileMaker Pro 9 and i maintain a database that contains scanned in files. I am trying to automate the scanning/record making process but to do this i need FileMaker to pull the … |
| | In the expression IIF[SSN]=50,99,[SSN]) when I enter 60, all works well. But if I enter 50, I get "The value entered doesn't meet the validation rule for the field or control". BTW, SSN is defined in the table as Number (Long Integer). What's the problem? |
 | hi ... Need help i need code for backup a database.. i want to place the code in a button... |
| | Hi. Now to start with I'm not asking you to provide me with a solid answer to this, but enough information so that I know where to start looking would be good. I have a project that I am working on which is an Olympic Database. I have several tables …  |
| | Hey All! I'm currently creating a database for a payroll system. I have a table consisting of Occupation_ID (primary key), occupation_description, normal_rate and then 3 different overtime rates. I've created a query to calculate the overtime rates for the different overtime rates, i.e. [code]UPDATE Occupation_Rates_Table SET occupation_rate_overtime_1 = Occupation_Rate_normal*1; [/code] … |
The End.