Search results

It does, I noticed that the Source query for the Contracts form had some null ContractSN fields so I removed those from the query in case that would affect it but still the same result Just for further info, There are no other matching fields other than Serial No / ContractSN There are no...

I can try and pull something out into a separate file I'll try and pull something out to get a working example but that might take a little time to do

Good Morning Everyone, Hopefully this will be quick, I am trying to tweak an existing form for a colleague Mainform :Frm_booking_In Subform : Frm_Booking_In_Detail Subform : Frm_Booking_In_Contracts Frm_Booking_In_Detail contains Serial Numbers [Serial No] (short text)...

incredibly sorry for the late reply everyone, Strangely I was dropped into two days of meetings with a partner company which happened to involve offering to potentially tailoring a bespoke mini erp for our company. Ignoring that, MajP, Gemma-the-Husky, Jason-lee-hayes, Pat Hartman, Cronk and...

I see what you mean, we might be able to provide some automation on purchased items in that way. The actual repair items is different but I'm sure like you said about the UI, there will be something that can be done there. I did think about a dlookup but the form is datasheet and i think i...

This is the trouble, after speaking to my colleague i cant think of any rules to pick these up, other than review and add to a "Bad Serials Table" and somehow use that, otherwise i'm stumped, even then i wouldnt be sure how to reference this bad list as a way of stopping these entries on the...

Thankyou for the replies MajP, Sorry about the following essay This was a new question brought to me by my colleague this morning, and to my understanding the scenario is mainly: example, items we purchase and use for repairs: x100 non oem parts/units, their SN (serial number) is "abc123" ...

Im afraid it cant be indexed, All historical serials from previous repairs are stored and there is always the possibility that the in that "Booking out" or "Shipping" that serial would be unique

Unfortunately there is no solid rule for "bad" serial number. If a single unit or a mixed batch of units are received for repair, in that instance the serials would be unique, and historically those serials could have been received and shipped multiple times before, even under a different part...

Afternoon Everyone, My colleague has a Repair Database, items are booked in by serial, booked out by serial. Sometimes multiple items (normally non OEM) have generic duplicate serial numbers. For receiving the items this is ok, but when sending the devices back out they need to have genuine...

I found it, Sorry everyone, i knew the moment i posted i would find where i was using the field. I had a control on one of the tabs that was uses query showing the 10 most recently entered Invoices... and of course the field was there, god knows why i put it in there twice but it was. Apologies

Hi there, I had a form called "Frm_Sale_Invoice" , There was a field called "DocumentType_ID" ( i was planning on AP and AR invoices in one table using the DocumentTypeID field to mark AR or AP) I decided to split this into two separate tables, So i deleted "DocumentType_ID" from "tbl_Invoice"...

Good morning, Well rather embarrassingly rebooting the pc seemed to have the desired effect, how could i forget rule one of IT helpdesk, IT crowd is running through my brain now. anyway, thanks for the advice

I'll give it a try in a bit, Im pretty sure i've rebuilt the form from scratch before and he popped up again at some point, might be something im doing

Hi everyone, A bit of a random question, a filter symbol has appeared on my form, it even shows up in design view. I have deleted all the objects, tried copying to form and it is still there, i cant select it or move it at all. Has anyone come across this before?

Sorry for the conversation, I will make sure to keep all questions on the forum as i should. Also thankyou for the advice again. I am having trouble with the long integer number data type though, it automatically rounds the values so im not sure how i can use to store calculated values?

I deleted all the textboxes and made a small function to call on the after update event of all fields involved with calculating the values. Function InvValueRefresh() Me.Inv2_GLT = Me.Inv2_Qty * Me.Inv2_Price Me.Inv2_Disc_Value = Me.Inv2_GLT * Me.Inv2_Disc Me.Inv2_NLT = Me.Inv2_GLT -...

As an example: the field labelled GLT is the table field Inv2_GLT GLT_Value is a textbox with the expression in the control source. of course not all the fields would be visible, i was the planning to update GLT with the 100.00 from GLT_Value but i am not sure if this is a good method or...

Sorry, So following advice i have added/moved more fields to my invoice details table. I was also advised that it can be good practise for invoices to store some of these calculated values in the invoice details such as Vat value and Line total Invoice details new fields now has: 1...

Update: Hi everyone, So for now i have added fields to the invoice details table, changed a few etc etc (fyi these are not the actual field names) Gross line total, Discount%, Discount Value, Vat Rate, (atm just a % number field but i will look at lookups etc with use of vat codes as well)...