1,597 Topics
 | |
| | Hi I have a very simple database which lists students who have went on exchange both in and out of our university. I am able to do a simple user entered query along the lines of [Enter university] or 'between [enter year] and [enter year]' but here is where it … |
| | Hi There Is There A Way To Make Access File As Exe File Thanks In Advance |
| | Private Sub cmdsummery_Click() Set wss = DBEngine.Workspaces(0) Set dbs = wss.OpenDatabase("Gagedetails.mdb") Set rss = dbs.OpenRecordset("tblGage") 'Set rss1 = dbs.OpenRecordset("tblopeName") Do While Not rss.EOF OSQL = "SELECT DISTINCT OpeName1 FROM tblGage WHERE Date =" & SQLDate(txtdate.Text) Set rss = dbs.OpenRecordset(OSQL) MSQL = rss("OpeName1") NSQL = "INSERT INTO tblOpeName (name)" & " … |
| | Some background: I'm a programmer, not a network administrator, who has been asked to migrate some accounting software ([url=http://ioasoftware.com]Integrated Office Accounting[/url] version 3.2) from an existing domain (OLD_NETWORK) to a new domain (NEW_NETWORK). No-body at the office knows how it works under the hood. It is a split Access 2000 … |
| | Can I require the entry to be +-5 mintues of the current time? Thanks |
| | Hi, I've been puzzling over how to connect these tables on Filemaker for hours, and hopefully someone can point me in the right direction. I'm trying to connect the tables in such a way that when I select a student, and a specific course, I will get all of the … |
| | Hello, I created a database in Access many years ago before I realized what a mess lookup wizards would make. Does anyone have any good ideas or resources of how I can keep the information but undo the lookup wizard? I have created new tables with the same information and … |
| | So, a single user application, all data is local, no remote access .... If a go with an Access file (DB), from the user's perspective, they simply install the app and they are good to go. Is it the same if I go with a SQL DB, or do they … |
| | 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 … |
| | Hello, i am working with vs2008 (web application) and I want to copy some content from an excel sheet and and using the clipboard i want to copy the contents in a gridview I have tried using Clipboard.GetDataObject() but no matter what ever i do it is always returning null … |
 | 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 … |
The End.