Search results

Hi I have a Sum Query called SumQuery [sumquery]. I want a text box [Text10] on a form [MainFrm]to fill with the result of the sum query [SumQuery] (one value only) when I click on a control on the form. The SumQuery uses a value off the form, a text box called [weekofyeartxt] as criteria to...

Hi I have a date control and on the Click event I run the following code. Trouble is the Date Control stops working, ie you can't change the date after one click ? CODE. Private Sub Calendar7_Click() weekofyeartxt.Value = DatePart("ww", Calendar7.Value) End Sub Thanks.

Hi I am trying to create query that will show the "total number of visitors we have each month". Just now each visit creates a record with the time and date of the visit e.g. 11/12/2010 10:05:33 I need to extract the month and year from each record and total the number for each month, (so i...

Hi do you get voice recognition software for access ? I know you get it for Word. gregor.

i have a report, and have a sub form on the report, i have made the box equal almost the whole page, but if the data for the report sub form is greater than the size of the sub-report form, it just cuts off the data? I need the sub-form on the report to expand to equal the size of the data it...

Hi I want to set the focus to a text box when i press "Ctrl X" on the form. What event should I use ? What is the code to let me do this ? Can you help ? Gregor.

Question for access forum Hi i have a database for a vets, and i have to print labels for them for the medicine. The main form has all the patient details and drug details. I have tp produce a report i guess and populate it with details from the main form and from an inputbox (drug amount). So...

hi i have 2 front ends and one back end with linked tables, that is working well, but over a wireless hub. I am going to use wires from the hub to the 2 computers so it is safer and less likely to corrupt. my question is will the router start sending the infomation down the wires, rather than...

i have two front end databases with one back end, the two front end use linked tables to the back end. One front end is on one computer with the back end in the pulbic directory, The other front end is in the pubic dirtectorty of the other computer. I can access both and use both front end...

hi, i have a database with a primary key that is autonumber. my client deleted a record so the autonumber field is not contiguious. ie it goes 166,167,169, so record 168 has been deleted. this is throughing out the number system she has. i am trying to insert a record 168 into the table but...

I have managed to set up 2 databases as 2 seperate front ends, and 1 back end access database with the tables only (using linked tables for the 2 front end programs). But when I try to do the same across a network i get a read/write problem, ie the front end programs open "read only record set"...

hi, i have 2 acess databases on 2 different machines on a net work. the two programmes both have linked tables to another access database on one of the machines. If both the front end programs are open at the same time there both open as "read only recordsets" . My idea was to have both the...

Hi i posted about spliting a database, which i did, it was to alllow more than one user to use the database at the same time. I have 1 machine (#1) with the tables only, and on the same machine a front end for the data with linked tables. On the other machine (#2) i have a front end with linked...

When you are writing data into a record on a form the icon changes from a triangle to a pencil, when you have finish writing/editing the data the pencil changes back to a triangle. What event is this ? So I can back up the data each time it is changed ?. Is it "On Change" ?

:confused: hi i have written a database for someone in access. They now want to have another user on the same wireless hub use the database at the *same time* as the first user ? I don't know how to do it or how it can if it can be done ? I also thought of writing some forms in visual baseic...

hi, i have a form "main" and a sub form "submain" i have some code in the sub form on a button click event. i need to take the infomation in the current record in the sub form and a piece of infomation in the main form, put them together and write the data as a new record to an unrealted table...

Can any one tell me why I get a type mismatch here ? private sub text78_keydown(keycode as integer, shift as integer) dim k as string if keycode = vbkeyreturn then k = me.text78.text docmd.openform "address query", acnormal,,,"[surname] = " & k,acformreadonly, acwindownormal end if end sub...

Hi I have data 1/1/2000 : aTime : Text 1/1/2000 : aTime : Text 2/1/2000 : aTime : Text 3/1/2000 : aTime : Text I need to return the sum of fields that have the same date. so, (2,1,1) as there are two entries for 1/1/2000, 1 for 2/1/2000 and 1 for 3/1/2000 can anyone help ? Gregor.

Hello, I have a problem with text boxes and memo boxes. When I do a form and am entering text into a text box,when I hit return the cursor sometimes goes to the next line and sometimes it goes to the next control ! The only way around this is to hit ctrl return to take a newline ? I am not sure...

Hi, I have a table of the following. --------------------------------- field 1--- field 2 ----------------- A-----------1 A-----------2 A-----------3 B-----------2 B-----------3 C-----------3 C-----------4 C-----------5 ------------------ I want to right a quiery to pull out the 1st, 4th, and...