Search results

Not sure what this error is for as I've not added any VB to the forms (not that I'm aware of anyway lol)

HI Gents, Thanks for all of this, I've got it working but I'm getting an error message "This object does not contain the Automation object 'tblPODetail'" This appears when I try to enter a new line in the PODetail subform section, I acknoledge the error and it works good and copies over the...

OK thanks, so should I create the relationship before making the forms if Access automatically then sets the links in the forms? Presume I do this in the relationship control after creating the tables?

Amazing, thanks guys. I'm flat out at the moment but will work on this tomorrow, thanks again and I'll keep you posted!

HI Gents, this is what I was thinking, but I'm not sure where to go after the following sequence: 1. Create new record in tblPO (POnumberID is autonumber - primary key) - Enter order heading, supplier, etc.... 2. Click on button to add line item - this creates a new record in tblPODetail...

Good Afternoon All, I'm wanting to make an addition to an already existing DB, the addition is for purchase orders, I know it's not possible but I'm trying to achieve some like a sub record, whereby the PO name is entered and then there can be up to 20-30 line items for that purchase order...

Sorry folks, managed to figure it out Between DateSerial(Year(Date()),Month(Date())-1,24) And DateSerial(Year(Date()),Month(Date()),27)

Hi All, I'm trying to write a query that returns the below: Between (24th of the last month) And (27th of the current month) Is straight forward for the first and last days of the month but am struggling with the specific dates? Any help much appreciated! Cheers

OK thank you, it's working for now, I've got about 3 or 4 queries dependent on each other to drag out the information and then group them into various groups of budget codes and also to take the same actual expenses for the same period and group into the same codes. I've probably over...

Perfect, thanks Between DateSerial(Year(Now()),1,1) And DateSerial(Year(Now()),[Enter Month],1) I'll get the hang of this one day! LOL

Hello!! I have a table with over 4000 records, each record as a date of the 1st of each month. This is an annual budget that holds budget data for 5 years for various budget codes. Does anyone know criteria I can use whereby I can enter a month (say 4 for April) and it will return all records...

Hi All, Thanks for this, it wouldn't allow me to add a folder as a trusted location, it just says it cannot add it as a trusted location for security reasons. I changed the ActiveXsetting to enable all controls and in Macro Settings I enabled all macros. This has worked but obviously not ideal?

Hello!! I have a DB that is on a server, when it opens I have to click on enable content every time, I've looked in the trust center settings and none of the changes in here makes a difference. I have an AutoExec file that runs but obviously I get an error as I need to enable content. Is...

Have emailed it through to you, might want to check junk folder

DoCmd.SendObject acQuery, "Export", acFormatXLSX, vRecipient, , , vSubject, vMsg, True I export it to an email attachment using the above

Row Source SELECT [tblDept].[ID], [tblDept].[Department/Charter] FROM tblDept ORDER BY [Department/Charter]; Column Count 2 Column Widths 0cm;2.54cm Bound Column 1

Bound Column is 1

Should have said also that the DB is split, don't think it should make too much difference though?

The tbls with the lookup info in are ID Code 1 1.01 dlkjcnsldc 2 1.02 dkcldc Etc. the ID is autonumber There are about 5 fields in the main tbl that all use different tbls for the lookup value