Recent content by ericv

Hi good question...reason for the setup is that the previous setup of 2 related forms where the user fills data into the subform did not have the format I was looking for. It must be a continuous form as there as so many entries, and the subform that is in the footer of the main form is just to...

The table being filled in is half pre-populated, so the user doesn't actually add new records to this table, he only filters, adds data in a few empty fields, then his entries is copied over to another table, and the first one is cleared back to its original state. So not sure, but don't think...

Hi, I have a data entry form (continuous) based on a single table, which appends data to another table through a query. This form has several filter buttons which helps the user to find the records he needs to enter data against. How can I build a button so that when clicked, it will...

Thanks all. Alas I had could not make it work the way I envisioned so took an entirely different approach. Thanks nonetheless for you comments. arnelgp, the continuous form with subform only work if you put the subform in the footer section of the continuous form. So you cant add it in each...

Generally I don't like the look of the record selectors, but if there's a way that it will highlight the entire record to a color I may reconsider...as far as my knowledge stretches it only has the little pointing arrow, or is there ways to format this?

I have a main form (continuous) with a linked subform in the footer. Is it possible to keep the setfocus and highlight a specific field in a record on the main form and only loose focus when another record is selected, i.e. even after clicking somewhere else like the subform the record stays...

plog...you made me rethink...I just had to create one searchbox for each field separately and "AND" them together...(now I feel silly) Cheers champ :-)

Awesome thanks so much! Got it going with purely joining the field names with "&" and "AND" all of them with each searchbox. Can filter any of 5 fields with 5 different keywords...pretty powerful. My syntax is a bit long winded though, how do I combine the "AND" so I don't have to copy it...

Hi all, I have a continuous form with some controls on the form header to navigate the records. The first is a search textbox which can look for 'like' keywords in any of 3 of the fields. This works perfectly: Me.Filter = "[FunctionalLoc] Like '*" & Me.Text79 & "*' Or [Description] Like '*" &...

Hello everyone. I'm fairly fresh in this business. Been getting into coding and DB's this year due to the need of managing asset data at my work. (I'm a mechanical eng). Anyhow, I'm busy building a fairly small app to manage statutory equipment on our site and will be asking for some advise...