Search results

Hi All, I have a table which gets joining and leaving dates for crew, it is something like this: SeatimeID, CrewID, JoinDate, LeaveDate The CrewID is linked to a crew table and so therefore the data in the seatime table looks something like this : 1, 120, 1/1/23, 2/1/23 2, 12, 12/1/23...

Hi All, I have a field in a table that holds file paths to PDFs of invoices, I am trying to put some code behind a button that attaches the invoices that have not yet been sent to the office, also there is a report that I would like attached to the same email. I have the code below but it is...

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

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

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

Hi All, I have the below code in the 'on format' event of a report footer, idea is to hide a subreport should nrecords>0, it works fine when I open the report and does everything expected, however when I print preview the report the subreport is missing when it should be there and it shows in...

Hi All, Is there anyway to make a report based on a new record just entered into a data entry form? FYI The data entry form also has a subform with the child table in Cheers

Hi All, As I understand I cannot put a continuous form within another continuous form.....is there anyway around it to display it as per the attached so it shows multiple parent and associated child records in a continuous form or report? In a perfect world I'd like it like this in both a form...

Hi All, I am about to go crazy 😩 Attached is a sample db of what I am doing. In the Expense search form there is some combo boxes and text boxes that can be used for search criteria, they are linked back to ExpenseQQ query. Currently I have just set the search criteria for the date, person...

Hi All, I have a subform within a form, the subform shows data based on a query that uses the main form for its criteria, when I open the main form 'Accounts' it works fine without any issues and the subform shows what it should. Problem I have is that the 'Accounts' main form is in a tab of a...

Hi All, I have three tables Expenses - Parent LineItems - Child Currency - Linked to the child with a drop down menu to select a currency All works fine and I have a form to enter the information into. However I have a field in the LineItems table called HomeCurrency, I need to add some VBA...

Hi All, Attached is a sample DB of an issue I'm having. Is easier to see the DB to see the problem. In the People Tab and then Sign on/off tab I have 2 subforms. I have code on click when you click onboard or onleave on the two subforms, in this code I have Me.Requery which requeries that...

Hello All, I have a query suppling a subform in a tabbed form. In the form I have a textbox that acts as the criteria for the query (LIKE "*" & ...... & "*" ) when the form it opened it returns all the records until a surname if typed into the textbox, so it works fine. Problem is that I want...

Dear All, I have a large DB which is currently split, I've worked on it over the last 5 years and as such it's quite disfunctional in that it could be designed much better in how it works (IE much less tables and queries etc.), but as you live and learn you figure out better ways to do things...

Hi All, I am trying to create a simple way that people can enter data into an email (in a perfect world some type of online form that I can send out a link to) then with this data import it into an access table. I've managed to get as far as a text box with command button that puts the field...

Good Morning all, I have some really odd behaviour on a split database I have. I have just imported a database into an already large split database. Once imported the new parts of it work fine, no problems at all. I then put only the tables into a different location, deleted the tables in...

Hi All, I have a button that opens another form, I want it to display the record with the highest ID (Autonumber). This worked fine using DoCmd.GoToRecord , , acLast However I have changed the sort in the qry the form gets its data from, as such now the ID's are not in numerical order so the...

Hi All, I need to make a query that will subtract the results from one query against the results of another, issue I have is that the results aren't equal.... Query1 (Last month cash ROB) Cur Amount EURO 500.00 USD 1000.00 GBP 50.00 Query2 (Cash used this month) Cur Amount...

Good Morning! I want to add a temporary field to a query that prompts the user for a yes or no answer. I can do this by putting something like " ILL: [Has person been ill] " in the query field, Only issue (and this is really first world problems! haha) is that the user has to type in Yes or...

Hi All, I've got a 10 page contract that I currently use mail merge from Access to populate, it works fine (ish) when I'm using it, sometimes it opens up and doesn't recognize where the data source is (could be that the BE is on a server), but anyway when I'm using it its no problem as I just...