Search results for query: *

Hi all, I would like to transfer an Access query to a workbook template in Excel. Some VBA code appriciated. Thanks in advance Kenneth

Hi All, Is it possible to transfer all table data from a table to another by using DAO? All fields are the same for the two tables. Some Vba code appriciated. Thanks Kenneth

Hi all, I have created the below on a form basically to open it hidden, check if there is any data (like if dcount()>0 and then continue or stop the code when necessary. My question. Is there any other way to accoplish the task with a simple Dlookup or an Sql code? Here's the sql; SELECT...

Hi, I'm building a database for a friend of mine who owns a tool hiring shop. I've create tables and forms (all unbounded objects) which update by DAO.I've stuck with a problem and cannot figure it out. Table fields are as follows: clientid; tooolId; datePeriodFrom; PeriodTo How can I allert...

Is it possible to make a query criteria from a table.

Hi all, Is it possible to create a crosstab query were colomn headings vary, ie fields are picked up from a form.(since headings change from day to day). I also, would like to be able to use it in a report. Thanks Kenneth

Hi all, I have five edit boxes in a form which ex a code. I want to stop code if all edit boxes are Null but not if one or more is filled with data. I tried the code below but with no success for obvious reasons- still not know how to proceed. If IsNull(Me.a1) Or IsNull(Me.a2) Or...

Hi all, I'm tring to use dcount or dlookup to verify an existing number in a table with no results. TransactionMain is the table-number is set to autonumber (table) and is the one to verify. a1 is an editbox on a form PickingNumbers.Code below; If DCount("TransactionMain![number]"...

Hi all With report I have created a no data Event. The problem arises when this event runs cause DoCmd.OpenReport "rptPickingList" is cancelled and a runtime error occurs. Is it possible to solve such problem? Thanks in advance Kenneth Agius.

Hi all, I've created the below code so if no records (in a report) are not found nothing happens. It doesn't work thou! Any suggestions Thanks in advance Kenneth Private Sub cmdpicklistregular_Click() DoCmd.OpenReport "rptPickingList" If Reports![rptPickingList].RecordsetClone.RecordCount...

Hi all I'm using two forms of which; a) is a search for an item code form b) is what about the item such description and plenty other stuff and details. Form a) is opened by a command button when needed. When a code is found from a search it is "pasted" on b) by double click. Here's the code...

Hi all, I have created a form which update a series of items from a for next loop in VBA.(The form contains 3 subforms). The problem is that after a certain time the screen stops updating. Does anyone there knows what I'm doing wrong? Is it bug? Do I need to install an upgrade? Access version...

Hi all, Is there a means to block all input from the keyboard/ mouse like you can block the screen updating with Docmd.echo..? Thanks in advance Kenneth.

Hi all, I've created a form which update certain data and transfers them to two tables...quite complex to explain in words. QUESTION1: Is there a possibility to create an updating status bar like the one in windows when you're installing a program, using an existing for-to-next-loop? It's not...

Hi all, Is it possible to delete a series of records in a table by DAO by using a query...maybe SQL? Example: I want to delete invoice no 12 and all it's records from a table have more invoice numbers Thanks Kenneth Agius

Hi all, I've created a cont. form (Stock Card) with Qtyin, Qutout and some other data which I would like to add a running balance; ie. Qtyin-Qtyout. I noticed that this is possible in a report by Running Sum. Is it possible to do this in a form Thanks in advance Kenneth

Hi all, I have created a database some months ago and I have added some fields recently. I would like to know how to fill the old fields with the new ones without going to paste in every cell Thanks Kenneth.

I would like to add, amend, delete Table records from VBA using ADO. I used DAO in the recient past but now I'm told the the technology is superseeded Thanks in advance Kenneth.

Hi all, I have a created a query from which I would like to extract data from a table. Once the query is run all table data should be cleared for another run. I don't know much about SQL. Can soneone help me please Thanks Kenneth.

I have created a query but I need to enter multiple criteria. I used "Between and " but it's not always usefull. I would like to enter for example 112,113,116,117 & 120. Can someone help please Thanks Kenneth.