Search results

Hi Has anyone experienced the following problem - I've set up a piece of VBA code to loop through and email various recipients data, in the form of records within the email body. This works fine, but occasionally produces an error whereby the email output body lines are duplicated spuriously...

Ladies/Gents forgive me if this question has already been answered a thousand times, maybe my search skills are worse than I thought. Is there a limit that Autonumbers generated will reach, after which it stops, or is it infinity? The reason I ask is that I have a database with a table inc...

Morning everybody. Could someone please tell me if its possible with code to refer to a specific line/row in a list box, e.g. From Listbox1 I want the data in row 3/column 2 for example. I know you can reference the column in a listbox. Hope this makes sense!

Hi all Is it possible to Sum the values in one particular column in a listbox, within either a form or report, and have the result in a textbox on the form or on the report?

Could anyone give me a clue as to why my a form in my A97 Dbase would change from data entry? = 'yes' to 'no' for no apparent reason, other than interference by another user? This has happened twice in 2 months, seemingly with no reason/set of circumstances. The form has been in use for months...

Afternoon everyone I have had a search on this and couldn't really find what I was after, forgive me if it sits blaringly obviously in a previous post. I have a table called "Xmaster", with a name field "Staff" and a time field called "from". There is a form "Star1" which has the textbox...

Could someone identify why the following simple Dlookup function is giving me errors? Dim intxy As Variant Dim intxz As Variant intxy = Forms!form1!vx intxz = DCount("[id]", "comments", "[ncrtype] = 'I' & [ncrno] = intxy") I have tried various syntax adjustments but I get either a type...

On an AfterUpdate event in a field, I have a simple piece of code which builds a unique reference number for a record, made up of 4 parts: "WEYRA" + "REF" + "Autonumber" + "03" The ref is input by the user, so if the user was to enter "DBASE" as a ref, the ref number built would be...

I wish to update a Textbox to "Null" using a combo box. I will explain..... I have a form with a listbox based on a query. The Criteria for the query are textboxes on this form. for example, the user selects values Open or Closed from a combo box. Textbox named"Status" is updated to value as...

Hi Can anyone tell me the best way to add a short time delay to a loop - When a form opens I am trying to create a gradual increment in tone (for aesthetic purposes) using: Dim counter As Variant counter = 0 While counter < 255 counter = counter + 1 Me.Detail.BackColor =...

I have a main form + a pop - up form which contains a listbox. When a value is clicked on from the listbox, I want to apply a filter (Which is save as a Query) to the main form. The queries criteria is based on the value in the listbox. Hope this makes sense. I have tried using the Applyfilter...

I have a main form called F0, and a suform called F1. When I click a button I wish to apply a filter (saved as a query) to put the data in the Subform in a certain order. I am having trouble refering to the subform in code. What is the correct Syntax? It currently is unable to find the subform i...

Is it possible to have a command which will place the cursor in a textbox a number of characters from the start of the text ?

In a Form or Subform, in continuous form view, is it possible to have the "Allow Additions" set to yes, but not to have the blank record waiting at the bottom of the form?

I have a built a simple append query which appends a temp table to another table. The fields and all their properties are identical, but i am getting validation error messages. Am I missing something or is it just me with my monday head on?? could the Date field have anything to to with it?

I have a Pop-Up form with just one text box. Is there a command so I can remove focus completely from any controls? I wish to have the Text box not highlighted as it has focus.

I have a form which prompts for entry of a name. AfterUpdate of this textbox, I have a set of labels which become visible. I wish to remove the focus from the name Textbox, so the text in it is no longer highlighted - is there a simple VB command to move focus to/from different controls when...

I have a table which records attendance for staff. Each record represents one day per staff. NAME ATTCODE DATE etc etc I want to find a way of grouping the records for a type of attendance code, where records are chronologically sequenced. I wish to find for example how many...

I have a form based on a main table. It stores records for staff attendance information, where 1 record = 1 day. I have a list box which shows all staff on a particular shift as selected by a combo box. This has a select query as its source. What I would like to do is when a button is clicked...

Good morning Could someone explain the most efficient way to automatically save a record in form view after data in a table is updated? There are fields on the form which are updated to certain values when events occur, but this data is not always saved in the table. (A97)