MSGROUPS.NET | Post Question | About | Groups | Contact | Register | Login



microsoft public excel misc (9093)

microsoft public outlook general (7339)

microsoft public excel programming (6569)

microsoft public word docmanagement (5607)

microsoft public excel worksheet functions (5040)

microsoft public access (4768)

microsoft public windowsxp general (3874)

microsoft public windows vista mail (2957)

microsoft public windows vista general (2783)

microsoft public windows live mail desktop (2699)

microsoft public office misc (2268)

microsoft public access queries (2122)

microsoft public powerpoint (2030)

microsoft public greatplains (1998)

microsoft public windows server sbs (1972)

microsoft public dotnet languages csharp (1964)

microsoft public access formscoding (1932)

microsoft public mac office entourage (1868)

microsoft public sqlserver programming (1861)

microsoft public access forms (1798)

microsoft public internetexplorer general (1706)

microsoft public mac office word (1699)

microsoft public access modulesdaovba (1691)

microsoft public outlook calendaring (1436)

microsoft public dotnet framework aspnet (1375)

microsoft public project server (1356)

microsoft public windowsupdate (1353)

microsoft public sqlserver server (1332)

microsoft public project (1285)

microsoft public excel (1277)

microsoft public access reports (1249)

microsoft public windowsxp help and support (1204)

microsoft public exchange admin (1185)

microsoft public windowsmedia player (1165)

microsoft public mac office excel (1160)

microsoft public windows server general (1100)

microsoft public dataprotectionmanager (1096)

microsoft public outlook (1035)

microsoft public word vba general (1029)

microsoft public vb general discussion (1001)

microsoft public outlook contacts (953)

microsoft public windows server active directory (930)

microsoft public development device drivers (911)

microsoft public dotnet languages vb (843)

microsoft public outlook installation (820)

microsoft public word newusers (808)

microsoft public word pagelayout (783)

microsoft public windowsce platbuilder (757)

microsoft public excel charting (733)

microsoft public publisher (728)

microsoft public excel newusers (711)

microsoft public windows powershell (697)

microsoft public pos (658)

microsoft public vc mfc (651)

microsoft public access gettingstarted (630)

microsoft public word application errors (629)

microsoft public sharepoint general (604)

microsoft public office setup (584)

microsoft public onenote (556)

microsoft public sqlserver reportingsvcs (550)

microsoft public outlookexpress general (539)

microsoft public frontpage client (532)

microsoft public access tablesdbdesign (529)

microsoft public scripting vbscript (528)

microsoft public windows 64bit general (512)

microsoft public outlook program vba (502)

microsoft public windows live messenger (434)

microsoft public windowsxp hardware (416)

microsoft public money (397)

microsoft public windowsxp basics (367)

microsoft public dotnet general (316)

microsoft public windows mediacenter (300)

microsoft public windows inetexplorer ie6 outlookexpress (276)

microsoft public mac office (272)

microsoft public win98 gen discussion (243)

microsoft public sharepoint setup and administration (225)

microsoft public windows vista hardware devices (183)

microsoft public windows vista music pictures video (178)

microsoft public nntp test (163)

microsoft public windows vista performance maintenance (148)

microsoft public dotnet framework (148)

microsoft public visio (128)

microsoft public access 3rdpartyusrgrp (68)

microsoft public access conversion (64)

microsoft public dotnet xml (58)

microsoft public pt windowsxp (38)

microsoft public access developers toolkitode (34)

microsoft public windows live photogallery (32)

microsoft public dotnet faqs (19)

microsoft public dotnet framework aspnet datagridcontrol (16)


microsoft.public.access.formscoding Post New
Items(1919) /39 Next >> Last >|
Subject Posted Replies From
puzzling data mismatch error

I have a table where one of the fields contain values such as 26-14-2C-R1-K1 15-13-1C-R3-K6 and so on. this is a text field I am trying to find records based on the part: R1-K3, R2-K4, R5-K1 etc. I am getting weird data type mismatch error when searching with my query. For example this works: SELECT myfield as P FROM myTable WHERE myfield Is Not Null AND right(myfield,len(myfield)-9) Like 'R1- K1' ORDER BY myfield but this one using a nested OR doesnt and fails with a data mismatch error: SELECT myfield as P FROM myTable WHERE myfield Is Not Null AND (right(myfield,len(m

6/7/2010 8:00:21 PM 2 Jesper F <jesperfjoel...@gmail.com>
How to enter multiple RTF lines in memo text box

How do I enable a user to line feed to a new, additional line to be entered in a form's text box which has a Memo field with Rich Text as its Control Source? Pressing "Enter" or "Tab" creates a new record in the table, rather than moving the cursor to a new line for continued entry? I will appreciate any help or alternative suggestions for a means for a user to create & edit a formatted text entry.

6/7/2010 6:36:55 PM 2 =?Utf-8?B?UmljaGFyZCBTLg==?= <Richa...@discussions.microsoft.com>
Spell Check specific fields on a subform

Hi, I have a form with a continuous subform that has four fields. I would like to add a button to my main form to spell check 2 of the 4 fields on every record in my continuous subform. The two fields are text input field and the other two have prepopulated information in them that does not need to be spell checked. How can I accomplish this? Thanks

6/7/2010 3:17:38 PM 0 shmoussa <shmou...@gmail.com>
Locking buttons

Hi everyone, this may or may not be possible but I'll ask the question anyway. .. I have a form with two butttons; each opening a different report. 'Report 1' button and 'Report 2' button. I also have another form that displays a drop down list where half of the list relates to 'Report 1' and the other half to 'Report 2'. Is it possible to make one button inactive if the criteria in the drop down list have not been selected in the other form? Thanks for any input you may be able to give me, Sam -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe

6/7/2010 3:15:00 PM 2 "SamMexico via AccessMonster.com" <u59...@uwe>
Exporting curretn recordset to Excel - only working first time!

The code below works the first time it is run - the displayed records are output to a excel spreadsheet called book1 with the worksheet named as it should be. So you open a form and click the button on the ribbon referencing this code and all the displayed records are transferred to a spreadsheet. However if you then try to run the code again without first closing and reopening the form you get a blank sheet. Any ideas? Also any idea how to make this work with an open table as well as a form. If I run the form on an opne table I get the error "2475 You entered an expressi

6/7/2010 12:38:27 PM 0 =?Utf-8?B?TG91dmVycmls?= <Louver...@discussions.microsoft.com>
Automating 'From'

Hi all From MS Access 2003, I have a routine in code that automates an email. I've tried posting in the outlook forums but no reply yet so I thought I'd try here too... I can autofill the To, cc, subject, body field etc but now I need to also send from a different user using the 'From' field. I tried adding this in the same way to my code using: .From but it seems this is not a supported method? I receive an Access error 438: Object does not support this property of method. Please can any one tell me if this is possible and if so how to do it? If I don't automate this

6/7/2010 9:56:14 AM 3 "Sue" <sportybabe...@hotmail.co.uk>
Text box with help instruction

Access 2003. Hello Forum I have a contnuos Form with two textboxes (txtbox1, txtbox2). When I click txtbox1 I would like it to display an instruction next to the txtbox telling for example: "Enter or write the City Name". If possible not a MsgBox. How could I get that? Or can anyone point me in the direction of some documentation that might help me. Many thanks

6/6/2010 11:49:09 PM 6 =?Utf-8?B?c2ViYXN0aWNv?= <sebast...@discussions.microsoft.com>
Can not get size of list width

For a form I am using ControlBoxField.ListWidth = 7.5 (or any other value) but resizes the drop down list width to the width of the drop down box. The help states that the value can not be less than the width of the control box - being larger should be fine. Instead I have to use ControlBoxField.ListWidth = 5000. The field for List Width under form (below column widths and list rows) is still set to 7.5. So why the different values required? Thanks, J.

6/6/2010 9:34:30 PM 6 "Jason" <J...@Yahoo.com.au>
Open form to ID and add in the record if not there

Hello, I have an issue opening a form to an ID of the record I am currently on. If I am on frmProjects and am adding a typing in a new EndUser from the dropdown in cboEndUser I want to be able to do two things: 1) Add this new EndUser name in the frmEndUserDetails in control source EndUserID (named cboEndUser) once I tab out of it 2) Have this new EndUser nae appear in the frmProjects once I finish adding details about this new End User in frmEndUser. So what happpens is that if I need to enter a new EndUser name in cboEndUser, once i tab out of cboEndUser the frmEndUserDetai

6/6/2010 5:18:26 PM 1 =?Utf-8?B?VmVsbw==?= <V...@discussions.microsoft.com>
Australian dates in access

Hey all, I have a control box in my form that asks the user to enter a date. It then takes the date and turns it into the default date so that it will show up on the next record. It accepts the date and saves it to the table in the correct format (dd/mm/yyyy) but then when it copies it over to the next form it converts the date into american format (mm/dd/yyyy). I have worked out it must be something to do with the code. This is what I currently have in the relevant section of coding. Private Sub DateFirstSession_AfterUpdate() DateFirstSession.DefaultValue = "#" & DateFi

6/6/2010 12:25:30 PM 3 =?Utf-8?B?TVIgRURERA==?= <MRE...@discussions.microsoft.com>
NumLock

When I use the SendKeys "{ESC}" (a very intersting instruction) in the Before Update, the NumLock will toggle Off the very first time. I have to toggle the NumLock manually back to on (one time). The second, third,... time everything is fine and the NumLock stays toggled On. Can somebody help me.

6/6/2010 7:09:22 AM 1 =?Utf-8?B?THVjIEJhbGxvb25QbGFubmluZw==?= <Luc BalloonPlann...@discussions.microsoft.com>
Combo box causes crashes

Hello, I have many combo box's in many forms that continue to cause Access 2003 SP3 to crash. Are there any official bugs on MS web page that describe why? If so can you send me a couple of links. These combobox's are pretty embarrasing and frustrating. ------------Below is the query the combo box runs, can you tell me if you see anything wrong? SELECT tbl_Category.Category, tbl_Category.Classification, tbl_Category.Category, tbl_Category.Desc, tbl_Category.ReportType AS [Category-Type], tbl_Category.[Remove Category] FROM tbl_Category WHERE (((tbl_Category.[Remove Cate

6/6/2010 5:34:07 AM 3 =?Utf-8?B?SXJhbQ==?= <I...@discussions.microsoft.com>
Data Entry = No

Hello, Below is vba on the On Click of a command button that is used to open a form called "frm_AltaDeRegistrosPagina1-2Analista", match the Record ID to the local form's Record ID, then make the "Data Entry" attribute = No. For some reason it is not working correctly. I need the vba to change the "Data Entry" attribute = No, so that I can modify the data on that form. The said form above is usually used to add records using the "Data Entry" attribute and via using the switchboard "Add Record" setting. Now I need to access the same form to modify records. Can you help me fix th

6/6/2010 2:27:54 AM 6 =?Utf-8?B?SXJhbQ==?= <I...@discussions.microsoft.com>
Forms acting strange.

There may just be an option somewhere that I need to change, but I'm getting really strange behavior from all the forms in a database I'm trying to lock down. I tried using code in the on open event of a startup form to hide the ribbon, and it wouldn't work. I tried everything I could think of, and I know the event was firing, but for some reason Access refused to hide the ribbon. I built an empty, brand new database with a single form and a couple buttons to run the same code, and in that file the code worked perfectly. But if I pasted the entire startup form into an old backup of

6/5/2010 8:38:47 PM 0 esn <ericnewk...@gmail.com>
Double Metal Jacketed Gasket

Sinston Sealing Material Factory is one of main exporter & manufacturers of sealing= material & insulation material in China . lies in Cixi city belonging to Ningbo area o= f eastern coast in China. There are 10 series main products : Seals gasket, gland packing, gasket sheet, seal t= ools, rubber products, PTFE products, asbestos products, fiberglass products, ce= ramic fiber products & mechanical seals , High Standard and high quality are appoint= ed as fixed-point products by many domestic middle and big enterprises , are sold far= to Japan , South Korea , Brazil , USA , United

6/5/2010 1:24:32 PM 0 "Martin Chan"<seali...@gmail.com>
Closing Access While Form Is In Print Preview Does Not Trigger Form Unload Event

We use the form unload event of our main form to make sure the user exist through our exit process instead of just closing access with the top right X on the access application. This works if the form is in form view. However, if the user uses the Office button to do a Print\Preview and then clicks on the top right X on the access application access closes without triggering the form unload event. Is this by design or a bug? Is there away around this behavior? Is there a way to prevent a form from going into print preview mode while still allowing the use of the Office button Pr

6/4/2010 10:30:53 PM 3 Stewart Berman <saber...@nospam.nospam>
combo box troubles

Hi, I have a form where if a (vendor) combo box field is "null", a msgbox pops up asking the user to choose a vendor. After a vendor is chosen, an order form pops up with the vendor info populated. All of this is coded on a button: if isnull(forms!frmInventory.vendor) then msgbox "Please choose a Vendor", forms!frmInventory.vendor.SetFocus *****more code here***** end if forms!frmInventory.vendor.value = vendor docmd.openform "frmOrders"... vendor = forms!frmInventory.vendor.value forms!frmOrders.vendor.SetFocus forms!frmOrders.vendor.text = vendor what code do I

6/4/2010 8:14:38 PM 2 "mapmaker" <u60...@uwe>
looping thru a continous form

I have a situation in which in the header of the continous form has 2 fields that list the warranty length (standard and max). In the continous form there are 2 fields of the same nature that feed off warranty fields (standard by line and max by line). But, the products in the continuous form will and will not have the same warranty. As new product is added (and can be more then one at a time) the line item should self populate from the warranty fields in the header. Now, a new contract (same product) is done has new warranty lengths. The product lead comes into the form and

6/4/2010 4:11:34 PM 4 =?Utf-8?B?Sm9obkU=?= <Jo...@discussions.microsoft.com>
2 list box iteration

I tried to process something for 2 list box and need to iterate 2 of them and one iterates selected items one iterates all list For i = 1 To lst1.ListCount For Each VarItem In lst2.ItemsSelected ' my loop is here Next VarItem Next i It seems that every VarItem increase the i increase as well. I want VarItem to be inner loop which should be finish all seleted item and go to next i. Where is wrong to use above code? Any information is great appreciated,

6/4/2010 2:49:08 PM 1 iccsi <inu...@gmail.com>
Number Error Problem

First of all thanks for reading my post. I have 4 number fields in my table. The default is set to nothing, not 0. In my form when I click on numbers 1-3 I have no problem. I did a msgbox on number 3 and 4. Number 3 field shows nothing and no error. Number 4 field shows a 0 and gives me a null error I have all the fields dim as integer Here is my code for number 4 field: Private Sub Unit4_GotFocus() MsgBox u4 10 u4 = Unit4 End Sub Am I doing something wrong? I have fields set up the same way as above and I don't have a problem. What I'm trying to do is to compare u4 w

6/4/2010 1:50:06 PM 3 "Afrosheen via AccessMonster.com" <u46...@uwe>
Tracking changes to a form's fields---still searching for an answe

I have a table and module set up to track all changes made to a record on my form. I am using the following code for the module: Option Compare Database Function LogChanges(lngID As Long, Optional strField As String = "") Dim dbs As DAO.Database Dim rst As DAO.Recordset Dim varOld As Variant Dim varNew As Variant Dim strFormName As String Dim strControlName As String varOld = Screen.ActiveControl.OldValue varNew = Screen.ActiveControl.Value strFormName = Screen.ActiveForm.Name strControlName = Screen.ActiveControl.Name Set d

6/4/2010 11:54:08 AM 7 =?Utf-8?B?WWFwcHk=?= <Ya...@discussions.microsoft.com>
create a form that collects parameters

Hi, i need a form where we search for a detail and the result should be published in the bottom, based on the result the user will decide what to do next in acess 2007. i refered the link below http://office.microsoft.com/en-us/access/HA100963141033.aspx#form_param in this some mistake is there in the macro can somebody help me out. if any template for search form is available please let me know. thank you, -- Kalai

6/4/2010 11:35:13 AM 2 =?Utf-8?B?S2FsYWk=?= <Ka...@discussions.microsoft.com>
Login with pwd & Open the main form depends on pwd

We have three groups of user that will use our database. Administrator (my boss & me), PowerUser (Manager / Supervisor) & NormalUser (clerk) Now, my front-end .accde will open my designed form – (main menu1) without any control. What we are planning are : 1. Users should have input their password (user can change by themselves) before they can login into the main menu. 2. Different class of user can open their own menu only (eg. Poweruser will open Frm_MainMenu1 & NormalUser will open Frm_MainMenu2 …) that depend on what password they input Could you give me some hin

6/4/2010 1:53:04 AM 1 =?Utf-8?B?YXc=?= <...@discussions.microsoft.com>
Set focus

Hello Forum Access 2003 I'm trying to set focus in txtStart, Private Sub txtStart_GotFocus() Me.txtStart.SetFocus End Sub but when form is open Focus is in another txtbox How do I set focus in a txtStart? Many thanks

6/4/2010 12:47:25 AM 4 =?Utf-8?B?c2ViYXN0aWNv?= <sebast...@discussions.microsoft.com>
After server upgrade some command buttons do not work?

I have a split database with the BE on the shared drive and the FE on each users' C: drive. We are using Access 2007. We upgraded to a new server on Thursday and on Tuesday I was notified by a user that their command buttons to open various reports were not working. The error they get is - The OpenReport action was canceled. I thought perhaps it was related to the trust center, since I had to update my trusted locations after the new install. I updated the trust center to the new server location in her copy of Access and I replaced her C: drive FE copy with a new FE copy. Netihe

6/3/2010 8:00:08 PM 1 "HLCruz via AccessMonster.com" <u27...@uwe>
recording the print date

Have a situation in which the printing (on paper) needs to have recorded the date the printing occurred. This would mainly be a field on the form that says when the report was printed. It won't make a difference how many times the report is printed so long as the date appears in a field. The users use the standard Access 2007 printing methods to print the report so adding a PRINT button on a form or the report is not acceptable. Is is possible to capture A2007's print button? If so, how is it done? Any samples, examples, or links will be helpful. Thanks.... John

6/3/2010 6:12:47 PM 3 =?Utf-8?B?Sm9obkU=?= <Jo...@discussions.microsoft.com>
Tracking changes to a form

I have a table and module set up to track all changes made to a record on my form. I am using the following code for the module: Option Compare Database Function LogChanges(lngID As Long, Optional strField As String = "") Dim dbs As DAO.Database Dim rst As DAO.Recordset Dim varOld As Variant Dim varNew As Variant Dim strFormName As String Dim strControlName As String varOld = Screen.ActiveControl.OldValue varNew = Screen.ActiveControl.Value strFormName = Screen.ActiveForm.Name strControlName = Screen.ActiveControl.Name Set d

6/3/2010 3:55:15 PM 3 =?Utf-8?B?WWFwcHk=?= <Ya...@discussions.microsoft.com>
OutputTo isn't avaialable now

I tried to send out emails when user launch the mdb. The application is able to send out emails, but I got OutputTo isn't available now message when I move the code to AutoExec marco or on FormLoad.The code only works after application running and click on a button. I just wonder is it possible to send out email when the mdb launch by itself. Any information is great appreciated,

6/3/2010 2:40:55 PM 1 iccsi <inu...@gmail.com>
Adding a command to a picture

I have inserted a picture onto my form and in the Event / double click set up a macro to close the form however when i double click on my picture nothing is happening - help!!

6/3/2010 1:02:22 PM 1 =?Utf-8?B?Y2FzaQ==?= <c...@discussions.microsoft.com>
Show only queries w/table source combo box

Is it possible to display only query names in a combo box where the queries source contains the table [Mstr List]? Thank you very much for any help.

6/3/2010 12:13:46 PM 1 =?Utf-8?B?QmlsbHkgQg==?= <Bil...@discussions.microsoft.com>
Testing numeric input

Is there a way to prevent input a Text-when the field requires a numeric input? Perhaps there is a function that test the input-type? Something like: Sub txtField_BeforeUpdate if "txtField is not Numeric" then MsgBox "Please give a number" SendKeys "{esc}" Cancel = True end if End Sub

6/3/2010 11:18:11 AM 5 =?Utf-8?B?THVjaWFubw==?= <balloonplann...@skynet.be>
shorter method than elseif

Hi I have a form where user will select a variable number of safety hazards by picture for each record the picture will have a path name which needs to go into a textbox on form. there can be upto 10 pictures per record choosen from 20 or more pictures i have started to write an else if statement but it is very long winded as can see below which runs on click of button the check box picures text are all in subform to mainform I thought about using array or tab control but not sure how to do this Thank you Tina Private Sub Command24_Click() If Me.Check3 = True Then If IsNu

6/3/2010 11:04:25 AM 1 =?Utf-8?B?dGluYQ==?= <t...@discussions.microsoft.com>
Multi-select list box for multi-column query

Hi, I have a list box lstBudVols from which I want users to select 4 items. Once these are selected, I want to use the selection for each as criteria for a different column in a query eg select 2010, 2011, 2012, 2013 in the list box, the output columns would be: TSL 2010 2011 2012 2013 xx xxx xxx xxx xxx I've done this earlier already using 2 different list boxes, but it would not be a smooth, well built database if the user had to select from 4 different lists. Is there a way of modifying: For Each vItm In Me.lstBudVols.ItemsSelected strWhat=etc I need to

6/3/2010 10:03:12 AM 2 =?Utf-8?B?bWVycnlfZmF5?= <merry...@discussions.microsoft.com>
Delete code competing with BeforeUpdate validation

I put code in the Before Update event of my form to verify that two fields are complete (i.e., Not Null) before saving. The code is: Private Sub Form_BeforeUpdate(Cancel As Integer) If IsNull(Me.FirstName) Then MsgBox "Please enter a first name." Cancel = True Me.FirstName.SetFocus ElseIf IsNull(Me.LastName) Then MsgBox "Please enter a last name." Cancel = True Me.LastName.SetFocus End If End Sub Also on my form is a Delete button that deletes the record. The problem is that if the user starts a new record, and then clicks the delete button

6/3/2010 3:10:26 AM 2 Kurt Heisler <heislerk...@gmail.com>
Add totals of record type to a form footer.

Hi. I've created a form with ~60 fields. 47 of them are combo boxes with 'yes', 'no' and 'na' options available. I'm trying to create a series of text boxes at the bottom of the form to show the counts of each selection (to be used later in determining a final score, so at the footer the user would see something like Total Questions; 74 Total Not Applicable; 24 Total Yes; 45 Total No; 5 I've so far tried playing around with the expression builder using the 'count' feature but can't quite seem to get the syntax right. Advice appreciated.

6/3/2010 2:26:52 AM 2 =?Utf-8?B?SlNjaHVtYWNoZXI=?= <JSchumac...@discussions.microsoft.com>
Iteration through a multi-Select List box

I have the following code in a form: Private Sub cmdQuarterly_Click() Dim strsql As String, oldipa As String, itm As Variant Dim rs As New ADODB.Recordset, rsgp As New ADODB.Recordset strsql = "Select ipa from tbl_mailing_groups group by ipa" If Not IsNull(Me.txtGroupid) Then oldipa = Me.txtGroupid rs.Open strsql, CurrentProject.Connection, adOpenForwardOnly, adLockReadOnly Do Until rs.EOF Me.txtGroupid = rs!ipa Me.Combo10.Requery strsql = "Select group from tbl_mailing_groups " & _ "Where ipa = """ & rs!ipa & """ Group

6/2/2010 11:13:18 PM 2 "RayMilhon via AccessMonster.com" <u59...@uwe>
AutoNumber, messed up sequence, duplicate values.

Hello, I have a database that is used by about 20+ users entering about 1000 records per day. I am noticing that they are having trouble adding records to the DB sometimes. When they have trouble, I go into the database table and try to add a record manually at the source and sometimes it tells me that the Autonumber is creating a duplicate record. As I scrolled through the data in the table I noticed the following.... Autonumber type field called "RecordID" 1-1085 looks good then it jumps to 3741 through 3749 then it jumps to 16864 through 17074 I know some peopl

6/2/2010 10:58:21 PM 2 =?Utf-8?B?SXJhbQ==?= <I...@discussions.microsoft.com>
Why is my DB always crashing when clicking the dropdown on ComboBo

I have a split Access 2003 Database. I have some people accessing the front end db from 80 miles away via a 1GB WAN Link and other people about 100 feet away from the server that is housing the db. For some reason and only some times, when they click on the drop down of a certain combobox it crashes the DB, asks if they want to send a report to Microsoft or End the Program. Then they have to re-open the db and try it all over again until it works. Would you have any idea why this is happening? If so could you help me fix this issue? Possible Clues Most of the Combobox's th

6/2/2010 8:39:11 PM 2 =?Utf-8?B?SXJhbQ==?= <I...@discussions.microsoft.com>
Locing records i nmulti user

Hi I have a multi-user Access 2003/2007 database. In mono user mode everything works fine, but in multi user mode there seems to be occasionally a Conflict message giving the users to either Save Record, Copy to Clipboard or Drop Changes. I open my tables something like: Public Function OpenTable(strTableName As String) As DAO.Recordset On Error GoTo FoutOpenTable Set ws = DBEngine.Workspaces(0) Set db = DBEngine.Workspaces(0).Databases(0) Set OpenTable = db.OpenRecordset(strTableName, dbOpenTable) ExitFoutOpenTable: Set db = Nothing Exit Function FoutOpenTable:

6/2/2010 8:03:34 PM 5 =?Utf-8?B?THVjaWFubw==?= <balloonplann...@skynet.be>
Database crashing

I have a relatively simple form and am trying to add a before update event to a combobox. When I try it open the vbe and allows me to create my code,but when I try to save or close the form/db and save, it always crashes?! Anyone have any ideas? QB

6/2/2010 6:44:02 PM 1 =?Utf-8?B?UUI=?= <...@discussions.microsoft.com>
coding between subforms

In Access 2007, I have a main form housing a tab control. On one page of my tab control, I have two subforms. The first subform lists my customers getting the data from a query in which I merge the first and last names and have a customer id (two fields). This form presents data in a continuous form list. The second subform has the detailed information on the customer. My goal and intent is to be able to click either on a button (linked to the customer id), the name of the customer, or even utilize toggle buttons (in which the caption is the customer name - preferred as a

6/2/2010 5:15:52 PM 6 =?Utf-8?B?S3J5a290YQ==?= <Kryk...@discussions.microsoft.com>
read focus of controls

I would like to set enabled to false, but sometimes the command button is on focus that I got error that I can not disabled controls when it is on focus. I wanted to check if it is on focus before disabled it, but I onlt find SetFocus method. Any property to read focus of the controls to check does the controls are in focus? Any information is great appreciated,

6/2/2010 3:44:52 PM 2 iccsi <inu...@gmail.com>
Apostrophe Problem

I use a control on a form which I have concatenated from the users First and last names. All works well if I select, Harry Smith, but when I select a name with an apostrophe in it, Kelly O'Malley, I get a run time error 3077. The coding is: Private Sub Combo80_AfterUpdate() ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[Name] = '" & Me![Combo80] & "'" If Not rs.EOF Then Me.Bookmark = rs.Bookmark End Sub Any suggestions? Thanks

6/2/2010 7:59:01 AM 3 =?Utf-8?B?TmlnZWw=?= <Ni...@discussions.microsoft.com>
Change GROUPING programmatically in reports

Here's the deal: In Access 2003, I have a report. I need to be able to change the "minor sort" programmatically via VBA (if I have to do that before I open the report, that's okay.) This would involve making changes to the SORTING AND GROUPING portion of the report. I would not need to SAVE those changes. the minor sort needs to change based on a set of radio buttons. The associated subtotals would need to be made visible/invisible based on that grouping. And assistance that someone could offer would sure be appreciated. TIA!

6/1/2010 8:30:01 PM 3 =?Utf-8?B?RGVubmlz?= <Den...@discussions.microsoft.com>
Employee Time card form

I have a table containing two fields - Employee_ID and Time_Stamp. I've already created a form that scans in Employee_IDs; and once any Employee_ID is scanned in, the ID and scanned time is recorded to the table. In addition to what it already does, the form needs to populate the employee's punch time records for the current week. For example: (current date and time is Wednesday 9:02 am) (Form view before update) Employee ID: ___________________ (Form view after update) Employee ID: _1001 (Enter)_______ ________________________________ Employee ID: 1001 Mon: 9:00 am

6/1/2010 6:44:02 PM 2 =?Utf-8?B?S2VpdGg=?= <Ke...@discussions.microsoft.com>
Pass a String Var to a Function

This may be an easy one, but I am going nuts with it. I have a routine that builds a string "em_body". I want to pass this built string to function called "email_build". email_build(embod as string) is the function. I called it with email_build(em_body) and fails do to mismatch, and of course if I call it with email_build("em_body") all I get is the words em_body, not the value. Please help Chris

6/1/2010 4:01:01 PM 1 =?Utf-8?B?RERCZWFyZHM=?= <DDBea...@discussions.microsoft.com>
Subform Code Question

I have a mainform (The One) and a subform (The Many) that displays data correctly. The problem: (The Many) can have one item or as many as nine or ten items and I need to be able to subtract an amount the user enters on the mainform from all of the subform items. The way I have it coded now it subtracts only the top or first item amount. How do you set-up a ‘Do While Not End Of File’ section of code in Access 2007? Thanks in advance -- KSmith

6/1/2010 3:30:01 PM 13 =?Utf-8?B?S1NtaXRo?= <KSm...@discussions.microsoft.com>
MoveNext

If I need to move down x number of records Is there some easy way to to do it other than movenext movenext a bunch of times or create a loop? I was hoping for something like Movenext(6) Thanks, Rick

6/1/2010 2:36:15 PM 3 Rick <rickhub...@gmail.com>
Continuous form record number

I have a form whose default view is 'continuous form'. Then when I click a button I need to delete the record where the mouse is (was just) placed. How can I find out the record number? Alternatively any idea is welcome. Thanks Henry

6/1/2010 10:26:34 AM 3 "H. Martins" <hjrmart...@gmail.com>
Can not choose in combo

Hello, I have a church membership database. I have the form to input the member data on whch form I also have a combo box to choose the address. If there is no address on the combo list, I add the member address in another form. I can only select it in the member form combo, if I complete filling the address and then return back to previous address. Can any body help me, that I do not need to return back in the address input form? in order to be able to choose it in the member combo form?. Sorry English is not my language, I can not explain it more clearer, but I think yo

6/1/2010 10:13:01 AM 1 =?Utf-8?B?RnJhbmsgU2l0dW1vcmFuZw==?= <FrankSitumor...@discussions.microsoft.com>

Pages: 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39









Newest Articles

Hi,ICopiedSomeTextAndPhotosFromAWebsite+PastedThemInAnEmailFromThi
1 hour 10 mins ago

Recover Format 400GB External Hardive
2 hour 6 mins ago

KEVIN J0HN PANNZKE WON the BATTLE
2 hour 49 mins ago

Cross apply from function not working
3 hour 32 mins ago

Mouse cursor freezes up semi-permanently with whole computer
4 hour 23 mins ago