Search results

Or another maybe better idea would be to have a subform to the side of the deckplan that just shows the job description of the dot that has focus? That way it would be easier to see just by clicking on the various dots what the job is?

This is amazing, thank you. Yes I think having a grey dot as an unassigned job is a good idea then when it is dragged to 'create a new job' the popup frm opens whereby its data entry and forces the user to select all items.

Thank you very much for this. I have made a few changes to the attached so it gives you a clearer picture. Basic changes would be 1. I have changed the table layouts to coloured dots that represent various priorities of jobs 2. I have added a Jobs table which would need to be linked to the...

Thank you very much for this, much appreciated MajP. Something like this will work well I think, I'll have a go and let you know! I notice in your thread you mention about this not working well when in runtime mode? I was planning to have the FE in runtime mode when I eventually split the DB...

Hi All, Not sure if this is possible? I would like a form that has a diagram of some plans on, this is the easy part lol I would then like the user to be able to 'create a job' and on clicking this button some vba makes a new button (or basically a small red circle) that the user can move...

The fundamentals of the DB are good, it was the subscription table that wasn't correct. I've amended this now and it is all working fine, thanks for everyone's input as always.

I don't see an issue with the design, just not sure you're fully understanding the needs of the DB as a whole. The Doc man said after seeing the relational diagram that he sees nothing wrong with the design. It works well without any issues. I had an issue with the Subscription table. I have...

For the subscription their will only be one lineitem per expense. It is for other expenses where there maybe more than one lineitem. Thanks for your help but this seems impossible so will stick with entering them manually each month, was only a nice to have

Agreed the currency field should be in the tblExpenses as all lineitems are in the same currency, I'm too far down this path already to change that now, plus it does give the flexibility for different currencies in the same invoice, this could potentially happen with a conversion to a 'Home...

SubDate > tbl.Expenses.ExpenseDate SubSupplier > tblExpense.Supplier CCUser > tblExpense.Person SubCurrency > LineItems.Currency SubCost > LineItems.Cost SubCode > LineItems.BudgetCode SubDetails > LineItems.Description

These are the fields in the Subscription table, as you can see there is data that needs to go in both tables (expenses and lineitems). This isn't the end of the world as it is only a few items that need to go in each month, it is more frustrating when I cannot do it and I'd rather find a...

Sorry not very good with SQL, can this be done in design view?

@GPGeorge and Gemma - These subscriptions only have one lineitem, however there are other expenses added to the expense table that have multiple lineitems per record (different budget codes and lineitems for one invoice), maybe the tables should be named tblInvoice and tblLineitem but...

Hi All, I got 3 tables: tblSubscription tblExpenses tblLineItems tblExpenses and tblLineItems are parent and child, connected via the ExpenseID (autonumber in expense table and foreign key in lineitem) tblSubscription holds information some of which is for tblExpense and some for...

Have figured it out eventually! I had not passed on the line you added If Not (rs.EOF And rs.BOF) Then rs.MoveFirst Once I added that it worked all good! Thanks again

Thanks for all your help on this. I have tried to use this same technique on another form which search/filters just the description and budget code of the line items, it all works good. When I try to open the report the message box indicates the records to be passed through to the report...

Amazing, thank you so much! Works perfectly

Hi MajP, I have a question/issue: The code for the above to put it into a report works fine but when I try to adjust the code to export that report to an email or excel it puts all the records in it? Any ideas how to stop that? The preview of the report is good and only shows the records in...

Hi All, I've seen quite a few threads on here about updating exchange rates automatically every 10 minutes from a hidden form whilst DB is open. I'm pretty lost with it to be honest is complex VBA, any help much appreciated how I could do it with the attached DB, I only need the currency...