Coming back to Access after a long time doing other stuff, there is one thing that really bugs me, which is that if you unwittingly open a query in Design mode, where the designer can't represent the sql (even if it's valid), the designer will 'correct' your query for you, and there is no undo... Is there a workaround for this - or an o...
I have a form with a few buttons. I want create a button which will execute all the buttons one after the other, after each function of the buttons has completed. Also, I would like to change the colour of the buttons to show which button is being executed. How do I do this? ...
For software used in a call centre guiding agents through a set script they must follow while on telephone calls, with the script branching dependant on answers to questions given - My system uses a MS Access / VBA front end (isnt web based due to speed, phone integration), 'call scripting' is coded in VBA when needed, but what if i want...
I have a vbscript which does the following: Open an access 2003 database Run a subroutine to populate the tables in the database Close the database Run a batch file which uploads the database to an ftp This vbscript is set up to run as a scheduled task in windows XP. When I manually run the script, everything works perfectly. If I ha...
Hi, I have an Access 2003 database with some visual basic code using ADO calls in it. When I do a strsql0 = "SELECT lnk_stockitm.C_C FROM lnk_stockitm WHERE (((lnk_stockitm.C_C) Like 'T*'));" newRS.Open strsql0, cn1, adOpenKeyset, adLockReadOnly newRS.movelast I get a '3021 either bof or eof is true or the current record has been ...
Hi, For years, we have been printing Word 2003 documents that have been saved to a OLE object column using an access report. We are using Access 2003. For some reason when we copy a Word 2003 document and paste it into the OLE object it does not print correctly there are subtle differences with the letter spacing. However if we use a...
Sorry if this is a newbie question, I'm a bit rusty in Access and even more rusty in Visual Basic! I'm trying to find a way of changing a field in a table when a field in another (unrelated) form is changed. More specifically, I'm after a way of reducing the number in the table by whatever the value is in the form field (in a stock cont...
I have a form/subform for inputting data into an ado table. The main form's recordset is a local table of Widgets and information about the widgets (WidgetID, WidgetName, size, color, location, etc). I am inputting test data (multiple tests per widget, all with unique dates) through the subform which is connected to an ADO recordset to...
Why does my Do Until loop try to run raw.Delete even though raw.EOF is true? If I have an empty table, this crashes. Why? Dim raw As Recordset Set raw = db.OpenRecordset("tblSampleRaw") If raw.RecordCount > 0 Then raw.MoveFirst Do Until raw.EOF raw.MoveFirst raw.Delete Loop End If ...
I'm trying to confirm or deny whether you can define a table column in MS Access 2003 as a set. It seems this is implemented in Office 2007 - you can define a column to have a 'multi-select list' in the query/lookup, but this feature appears to be unique to the new access 2007 file format as far as I can determine. Worded another way, ...
I am trying to hide specific columns in an Access 2007 split form through code. I need the form to check certain conditions to see whether it needs to display a column or not. I have code in the form's 'Activate' event to hide the column like this: txtControl.ColumnHidden = True This code works in the "Open" event, but if I hide the c...
It didn't always do this, but ever since I split my database and made the front-end an ACCDE file, any time I try to compact and repair either file, a new file called "Database 1" is generated and my original file size doesn't change. Is this normal? My ACCDB is roughly 20MB, and my ACCDE is just over 1M after being used the first time...
Hi. Sorry in advance for the rookie-ness you are about to hear..... I have VB application that uses an Access DB, call the database: db_1. For reasons best left unsaid, I have to substitute an Excel worksheet for db_1 - as far as the VB application is concerned. I hope to populate this new data on the worksheet, link the sheet into t...
Setup: One table called documents with columns author_id and reviewer_id (among others). One table called users with column user_id. I need to create two referential integrity links: One-to-many between user_id and author_id. One-to-many between user_id and reviewer_id. In other words, these two columns in documents are independent of ...
I am currently "forced" to create a database in ms access 2007. Due to replication issues i have decided to use autonumber as ReplicationID for my Users table. On my venues table i would like to use this id as the user created. I have tried to use the userID in textboxes accross the main form, but it outputs {guid {BF40D0A0-A1F3-4C9...
hi all I want to write an app that uses a Access database (*.mdb). I know how to connect to a mdb and how to use SQL statements. My problem is that I want to put the result of a query into a TListView. Any info/link/book is welcomed :) ...
Is it possible for Flash or possibly Adobe AIR to have access to a local Access database? I will have either a Flash EXE or AIR application running on a local PC (WinXP). The PC will also have a local Access database. I need my Flash application to get the data from this Access database. How would I do this? I doubt it can be done with...
please tell me how to change this access code so that radio buttons are removed and on clicking the import button itself the all 4 excel sheets are imported ( in other words code of all 4 radio buttons is excecuted ). I'll be glad if you can help me out however negative comments are most welcome as well :-) Option Compare Database Opti...
please tell me how to write this query i have an access table number 2 2 1 2 2 1 1 3 2 i want a query that gives number count 2 5 1 3 3 1 any help appreciated ...
I have two MS Access tables: tableA num state 1 12 2 13 1 11 3 12 tableB num stateA stateB 1 12 11 1 12 11 2 13 12 2 12 11 1 12 11 1 15 11 3 12 11 How can I create a third table which will have only one column num - appended from two table...