Search results

I think maybe the confusion is from me; typing before really thinking, missing something out! Set up your 3 reports, using the relevant table/query, in the formats required. Then use the view and WHERE parameters of the OpenReport method to set the Client ID and print the statement (not just...

You have a print statements routine, that loops through your client table in alphabetical order. For each client, you print the relevant report. I assume currently you do something similar, except you determine which subreport to make visible. Sub PrintStatements() Dim rsClients As...

Hi FogLog If you think about this, you are just using seperate reports and seperate report (templates) is the way i would go. Have a field in the Client table to ID the template, a table of TemplateID & name (eg Temp1, Temp2 etc). Then at print time open up the relevant template. If at print...

The hyperlink path does not need to be displayed on the form, just display the name. Either a function to extract and display OR an extra field that stores the name. That way your code is simplified to Application.FollowHyperlink Me.PathToWordDocField

I think that is the best way. The way I would avoid duplicate emails is to have a Sent Boolean field in the TblContacts table. As you iterate through tblAssign to allocate the addresses, only include the contact if the Sent field = FALSE (and set the Sent field to TRUE at that point). At the end...

hi Infinite To do this you need to create a query that sorts your data by the Month and the Year. I generally add 2 fields (TheMonth and TheYear) using the Format() function EG TheYear:Format([Date],"yyyy"). Now you have to decide on mess or clarity (HINT - CLARITY :rolleyes:) It comes down...

I like 99% of chocolate but its the weight gain that drives me up the wall:banghead:...I still eat it though, yummmmmmmm :D zooropa67 I would suggest that giving up something for a few irritations is rash. Yes there are issues that the Access community has long argued and complained about, but...

hi skkakkar, This post should be in the Excel section, perhaps a mod will move it? To answer however, you need this line of code after generating your list ActiveCell.FormulaR1C1 = "=COUNT(R[-" & Counter1 - 2 & "]C:R[-" & Counter1 & "]C)"

ListIndex (the current selected item) starts at 0. Check the code is identifying the correct entry in the listbox.

Hi the-m0th, easy to lose track of time :) The first bit would be code to flag and unflag a record and would be in with the forms code. So typically setting would be done using the Current event of the form and unsetting the BeforeUpdate OR in a button_Click event (save record or something)...

Hi crossy5575 I do not want to misdirect you or run interference on Dave's (see some of us know Gemma was the name of your dog :) ) advise thus far. I have been involved in logistics for 25+ years, much of that in a stock control related environment. FIFO is a bitch (sorry if the language...

hi Azhar.iq SQL strings need to end with a semicolon ; I assume HeadID is a number? needs to be in ' ' otherwise. Although it may not affect anything, i find it helpful to always enclose field names in [] brackets and CAPITALISE keywords like VALUES.

hi masoud_sedighy I can see a way to achieve this with coding but not queries - although i am sure it can be done with queries. From a code viewpoint you would need to loop through each PO in the table,adding each book one at a time to a box. Loop through PO table Loop through contents of PO...

Here is another thought for you. Irrespective of what avenue you take, you will need a spec document - either as a road map for you or an external developer OR as a 'shopping list' to ensure an off the shelf system achieves what you need it to. So draw up that document, in general terms; What...

Hi cjacobsen4 You could check for the day of the week using WEEKDAY() function and adjust the date range accordingly. In simple terms a formula like: Iif(WEEKDAY(DATE,2)=1,>DATE - 3, =DATE-1)

Yes, that is right. You can not build 1 string to do it all, you need to add each selected item one at a time. So once you have the string EG "INSERT INTO [Contact_Networks] 2,5" you run that as SQL. So with 3 networks selected (say 1,2,3) on the record for Contact 1, you would get "INSERT...

Let me just check something. I would expect to see; Contact table ContactID - PK .....other fields Networks Table NetworkID - PK .....other fields Contacts_Networks table (to use your terminology a bridge table) TblID - PK ContactID - FK NetworkID - FK So on a form displaying a...

You would need to use VBA to do this. I would have a listbox of the on line networks (multiselect) and a command button to trigger the VBA. Once the user has selected all the relevant networks, they click the button.The vba would need to loop through all the entries in the list box and identify...

Hi the-m0th You would not need this in code. In A2013 (and 2010 i think) you can apply record locking on the form itself (see the forms property sheet Data tab). In earlier versions of Access i think you set this for the entire DB. If so it would be under in the Options settings, probably...

How long is a piece of string? :banghead: Seriously? It depends on how quickly you can learn about relational databases. MS Access is, IMHO, very easy to get up and running with simple requirements. You already use VBA, but do you understand VBA? Methods, Properties, Events etc. Again if you...