Search results for query: *

Rizunb - What version of Access are you using? MS has KB for this task for 2000 & XP. KB285822 Access xp Code http://support.microsoft.com/default.aspx?scid=kb;EN-US;285822 For 2000 - http://support.microsoft.com/default.aspx?scid=kb;EN-US;198755 HTH - Michael

Is there some reason you don't just multiply the original value by -1? If you only want to convert positive numbers than check it see if number is > 0 before making conversion. I Michael

USCitizen - This might give you another option. Much of the code is from a few different MS Knowledgebase articles. There is quite a bit of code here, but you should only have to do the three things numbered below. 1. Create table named tblUpdated. The table has five fields. The structure...

UsCitizen - I think your problem is the subform is actually a control on the main form-therefor an change on the subform shows as a change to the parent. The mickeysoft Knowledgebase has article Q210210 on this topic. Michael

BLBurden - How about something like this? Make a button for your form and put this code in the on click property. Me.Filter = (([date_entry] = date)) Me.FilterOn = True DoCmd.GoToRecord , , acNewRec 'intnum is the name of the field I used to hold your daily counter IntNum =...

Ginorom This code will add the ages of selected items. Sub Command2_Click() Dim frm As Form, ctl As Control Dim varItm As Variant, intI As Integer, ncount As Integer Set frm = Forms!form1 Set ctl = frm!List3 For Each varItm In ctl.ItemsSelected ncount = ncount +...

Ginorom - I am not sure I understand what you are trying to do. I'll take a couple shots here. 'This would print the value from the 2nd column 11th row in the active form for a listbox named List0. Remember listboxes are 0 based. You can pass variables if you want to change the criteria on...

Albyh - Hope I understand what you are asking. Sometimes free advice isn't worth the price. ;) The code below took your original function and I copied a bit of code from MS Access help. The code reads a textfile in and stores it to your mesagetxt variable. There is also a commented line that...

Sanders720 I haven't played with the orderbyon property much, but that might be what you need to check. I made a simple form with two checkboxes custno & Prevno. Viewed in datasheet mode the form will change the sort and apply the sort based on the checkbox that was selected. Private Sub...

Mike - Is linking through ODBC an option for you? I connect to Oracle tables, spreadsheets, and other Access files through that method and just use the gui to create querys connecting the tables together. Michael