Search results

Afternoon everyone, I have a button on a form with a macro to open another form. This works fine. I want to change this to vba, so i open the macro, delete it and save, remove macro event and add the vba.. when i save the form and click the button it pops up with the following: Once this...

Afternoon everyone, (apologies if this is the wrong group) I am currently trying to piece together Purchase Order and Goods Receipt to add onto a database. I need to be able to receipt against the order line, either partially or complete. Ideally i would like to essentially bring up a copy...

Good morning Everyone, I have a module I sourced from online, that inserts before and after values into an "Audit" table. Called from the before update event of the form and uses the format Call AuditTrail(Me, ID). This works perfectly fine for every form I have used it on, until last night. A...

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)...

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...

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"...

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?

Hi there, I have a draft form for invoice creation, (i know there shouldnt be '-' in names but this was made a while ago) Stage-1 main invoice Stage-2 product details/costs etc At the moment the autonumbers are the PK's but INV-1-Ref is the actual invoice number My question is, is there some...

Hi everyone, Im currently looking into exporting a simple query to excel (weekly orders status) Im hoping for: Export on click custom filename Open & format as table Close and Save maybe open MS outlook and attach to an email Im following a Youtube tutorial by "Access Jitsu" using the...

Hi everyone, I have a very long If statement which i have realised only applies the "AND" to the last "OR" I have entered. Basically i have a dropdown box and once the record is complete, depending on the "Move_Reason" certain fields can or cannot have certain data in them. Some "Move_Reason"...

Hi everyone. In my database its normal to scan a serial number for an item and see where it was last used (Movement, Shipment, etc) Currently I have a form with a textbox to enter the serial and then a query displaying the related movement from the movement table. But I would like the user to...

Hi everyone, im hoping this is an easy question to answer. I found some code online for add or subtracting working days and excluding holidays utilizing a table to list the bank holidays etc. the function seems to be switching the dd/mm if its possible, i have a holiday date 10/04/2020...

Hi everyone, Im hoping someone can help with this. I have a Splitform"Stocktable" and it has a subform "StockMove" (The splitform only displays the datasheet half and the individual fields are hidden) A user will select a line/record in the Datasheet and relating stock moves appear in the...

Hi there, I have several forms (sales order, purchase order, invoice) that all use one "notes" form. When i click a button on the origin form it opens the "notes" form and populates the "Tbl_Note_Parent_Ref" field with the reference from the origin form but.. if the origin ref ([crm-1-ref]) is...

Hi everyone, Im jordon. I've been working on Access for about 5 years now but i've never learnt any VBA etc, i've just googled to find solutions to get things to work. Anyway im starting to focus more on the VBA aspect on my database but it is difficult as i cant write any code without having to...