Search results

Thanks for the info. I'll start looking into that. There are a large number of records on that particular table. I'm working on a database that was written by someone else but from what I can see stepping through the code: the local table gets cleared out all the indexes are then deleted it...

Hi All, I've got a really weird issue creating an index for a table. (nb: table, index and field names renamed below for clarity)I have a table (Table1) that contains an unindexed numerical field (Field1). I have a query (Query1) that contains the following SQL: CREATE INDEX Idx_Field1 ON...

So you're trying to run a passthrough query and want to send it a parameter? I'm guessing everyone who is using the Access front end has their own copy? If so, you can create a generic passthrough query that gets altered on the fly. All you'd need to do is generate the text for the query...

When you say "Activate" do you mean run the underlying code? re-reading your text the buttons are in a subform? if so, just make the sub code for the button public and call it. Something like this: me.MySubFormName.btnMonth_click

Am I right in thinking you want button 4 to have the focus on the form when it opens when the month is April (as an example)? If so you don't need to do anything with sendkeys. call your buttons BtnMonth1, BtnMonth2, BtnMonth3 etc. in your form open sub stick this in...

Something like this should work Option Explicit Private Declare Function BringWindowToTop Lib "user32" (ByVal _ hwnd As Long) As Long Private Declare Function FindWindow Lib "user32" Alias _ "FindWindowA" (ByVal lpClassName As Any, ByVal lpWindowName _ As...

so Nz can be used to return a value if a variable (or function / calculation) returns a null. So you can do something like this: DoCmd.OpenForm "CTableSearchF", , , "[ctable].[lastname] = '" & Nz(LastNamestr,"Name Unknown") & "'" And "[ctable].[phonenumber] = '" & Nz(PhoneNumberstr,"Phone...

Sorry, not quite sure what you mean. However, have a look at the properties of the form in design the view. There's a setting in there to define the order. Off the top of my head I think it's called "Order By".

Almost. You need one "Set" at the beginning. The other 2 lines shouldn't have one. also, the 2 lines need commas have a quick look here for a brief description of the sql UPDATE synatx: http://www.w3schools.com/sql/sql_update.asp

As an alternative, you could also grab the active control's parent name. eg. MyTabPageName = MyControl.Parent.Name MyTabsName = MyControl.Parent.Parent.Name NB: I'm paraphrasing here as I'm nowhere near my Windows machine at the moment. For a bit more detail, have a look at...

Hi, I'm not sure why this was set up as a function as it doesn't return a value. However, it looks like it's supposed to step through all the checkboxes in the form. If any are ticked it grabs the caption from the checkbox and adds it to a list of values to search for. What's the error message...

Yep sorry. Half asleep!. This should do: DoCmd.OpenForm "CTableSearchF", , , "[ctable].[lastname] = '" & LastNamestr & "' And [ctable].[phonenumber] = '" & PhoneNumberstr & "'" Also it might be worth chucking in a couple of nz's in case you have null values in the vars.

I think you've got a " in the wrong place. try this: DoCmd.OpenForm "CTableSearchF", , , "[ctable].[lastname] = '" & LastNamestr & "'And [ctable].[phonenumber] = '" & PhoneNumberstr & "'"

Blimey. OK, you're going to need a decent api to connect to. Because you're generating forms you'll need something quite well documented. A quick google search for me turned up this: http://www.adobe.com/content/dam/Adobe/en/devnet/acrobat/pdfs/iac_api_reference.pdf it's a bit old but on page...

If you want a specific value set when you can't find a record, you can use the NZ function. eg lkup = Nz( _ DLookup("[tp]", "flcalc", "[fl] = " & jk & " AND [nettot] = " & n1(jk)) _ , "No record found")

Hi Ant, You can download the Hebrew Cal class module I wrote a while ago from here: http://www.linkitdesign.com/customer-area/downloads/public-area/downloads/product/ms-access-hebrew-date-class

Oh hang on... Here you go: http://www.access-programmers.co.uk/forums/showthread.php?t=201939

Hi, I've definitely seen vba code knocking around in the past for Excel that uses PDFCreator (open source) to generate PDF docs. Perhaps it could be adapted to do what you're after.

Thanks for the codeplex link. I'd still like to know what licences people recommend. I can see the resources on codeplex use various types of licences. At the moment I'm thinking LGPL is probably the way to go.

Hi Jon, It looks ok to me but if you want, have a look at the silktide wizard page. There's options for a bottom bar instead. https://silktide.com/tools/cookie-consent/download/ The Advanced docs also say you can define your own css theme as well if needed...