microsoft.public.access.modulesdaovba | Forum profile

  Wiithout looking at your actual code, and just a shot in the dark to boot, I would be suspicious of using the square brackets [] as characters in a filename. Aside from how the filesystem might handle these (I don't know how), these to have a special meaning in VBA and there's a good possibility that somewhere in that code of Mr. Lebans there may be some issue with perfoming the conversion. The lack of extension also...

  In this specific case you'd need to create a custom function. Below is one I threw together rapidly to try to help you out. It is not the most elegant way to do this but it does work. Feel free to improve upon it. Function NoDaysByMonth(dtStart As Date, dtEnd As Date) As String On Error GoTo Error_Handler Dim iNoMonths As Integer Dim dtFirstofMonth As Date Dim dtLastOfMonth As Date iNoMonths = DateDiff("m",...

  Please ignore my request. I have learned a bit more about the problem and have reposted it as subject "Secure Hyperlink Fails".  

  Hello, The following code gets me close, but not quite. When this runs, I get an error that the field doesn't exist. It's reading the text in the field as if it's a field name. I'm just trying to copy the text string from Pic_Location to the clipboard when I enter an unbound text box so it's ready to insert into the next chosen record. The code is: ****************************************** Private Sub...

  Another way to get at this would be to create a query. 1. To do so, you would need a table (tbl_Numbers) with one field (intNumber) with 10 records (values from 0 to 9). I use this table for lots of different purposes, but generating date sequences is the most frequent. 2. Then, you need a query (qry_Numbers_to_99) which generates a sequence of numbers from 0 to some other value (in your case you probably only need < 100...

  TextBox1 is a control within SF_SourceObj. Main_SubForm is the name of the SubForm\SubReport section. Maybe i didn't explained me clearly on the first post. "RonaldoOneNil" wrote: > Me!Main_SubForm.Form!TextBox1.Caption = "Test" > > "Luis" wrote: > > > Hello. > > I have a form ("MainForm") with a...

  Excellent! That works perfectly! Now on to part 2 - is there a way when the picture is missing to move my text boxes to the left and over the ImageFrame? In other words, do something like: Me.Text1.Left = 0.0417 Me.Text2.Left = 0.0417 ... Where would I put this? Thanks for all the help! -- Albert S. "Dale Fye" wrote: > Albert, what you need to do is test to see whether either the gif or jpg file >...

  variable = DLookup("fieldname", "tablename", "where clause") this is the code for getting table value into variable like that how to change table value to variable value (i.e table1.field1=variable) "Jack Leach" wrote: > Search the help for DLookup (or go to www.allenbrowne.com/tips.html and > import his ELookup function). > >...

  "Ann" <Ann@discussions.microsoft.com> wrote in message news:DA55CFED-CAC6-4377-AC8F-14E88A67B7A9@microsoft.com... > Hi, > > I'm a beginner and I'm having a problem with my "and" and "or" statements. > I understand why it's not working just not sure of the syntax to make it > work > correctly. This statements...

  You have not shared the code you are using so hard to say what you are missing. However, try the following link and see if that points you in the right direction. http://support.microsoft.com/default.aspx/kb/827423 -- Regards, OssieMac "Norbert Meiss" wrote: > I use a multiselect listbox to let a user select multiple items. The items > selected are determined n the AfterUpdate event. In most cases...