Search results

Have a look at this site if your still struggling http://www.fontstuff.com/access/acctut09.htm

hi if you have a combo box that has two coloums, and you display the second (applicant name) but are bound by the first (applicant id). how can you refer to the value the secondary coloum contains in your code? I imagine normally you can use combobox.text but in the function im using this...

Ive got what i want to work in some fashion,im trying to build up a letter in word using bookmarks that have field values passed to them. The values from the main form are being passed but the procedure is ignoring values from subform? code is below any ideas? (the sub form is called...

How do you start word 2000 from access 2000 In a code example im using it simply states Start microsoft word. This brings up the (expected end of statement error")

What is the advantage of using mail merge? It has been suggested to me that i use mail merge in the current application that im building. This is mainly because my client needs to send a lot of custom letters that will be different each time one is sent. From what i know about mail merge you can...

What is the advantage of using mail merge? It has been suggested to me that i use mail merge in the current application that im building. This is mainly because my client needs to send a lot of custom letters that will be different each time one is sent. From what i know about mail merge you can...

Thanks, since descovered you can reference it through this approach as well generic_array(3, 2) = Me.Parent![Sub_form_interest]![interest_date].value

Hi, im setting up a facility (check boxes that need to be true) in a subform that looks at values on the main form and other associated sub forms to check they have values before the user can move to next record. I'm using an array (variant) for code reuse and functionality, i can read the...

Hi, two questions 1) I want to set up a multidimensional array, the array holds field names horizontally and their values vertically. the X dimension will vary depending on how many fields are being passed to it which will vary, the Y dimension will only be two deep, row 1 the field name, row...

HI, i have a field in a query called [cost_type], these typically contains the values "principle works" or "additional works" how can i set the query up so that it doesn't return the "works" part of the record? Could i just return the first 10 characters of the result? thanks

What do you mean by the image frame & how do u set one up? Do you mean a image control or an unbound object? I take it you have called it ctlImageControl as well or am i looking at this wrongly?

I have tried fitting your code into my application, i cannot compile the code though. I get the error with the line CallDisplayImage the error states function not defined, if i put a space after call then the error changes to arguement not optional, guess this is because it expects...

hi, a desirable feature of a databse im building would be for the user to upload a jpeg image to the database. Ideaaly for simplicity it would be better to just save the image in a specific windows folder and then save its filepath as a hyperlink in a related table. Is it possible for access to...

hi, i have to perform some calculations in a query based on criteria based in it. i need to look at a applicants VAT status then a companys VAT status and decide whether VAT is to be included. How would i go about doing this in a function rather than a IIF? there are 3 possible scenarios! How...

is it actually possible to place a tab control within another tab control? every time i try to put one on it ends up beneath? would be good to have because even with one tab control my forms still look very busy!!

hi, ive adapted this code to fit my application and it works. Any ideas on how i could make this into a global module so it can be reused through out application? ive tried the following but i get an error if i try to assign a null value to a string? are their any ways round this? Form code...

i have found another way to do what i was asking for, it is Public Sub tab_options() Dim strindex As String strindex = Me.tabOptions.Value() '' this code gets the value from the tabpage in focus TextMessage.SetFocus '' need this to set the focus to the textbox, Select Case strindex Case...

Hi, i have a tab control on my page, below it i have a text box. I would like the text box text to change depending on which tab the user is pointing at. I guess its something to do with the page index property. How do i refererence this in my code? the only relevant code ive seen is...

I have got round my previous proble by using the following code, there are still a few bugs that i need to iron out though Option Compare Database Dim gsecond As String Dim gTable As String Private Sub Form_AfterDelConfirm(Status As Integer) after_delete (gsecond) End Sub Private Sub...

I have tried the first piece of advice and it brings up the error "wrong number of arguements or invalid property assignment" With the second i could use that but it would mean putting same code on all my delete functions. I wanted a generic delete module that could be called from any of the...