Search results

Customer wants a monthly invoice by all dates to show any activity or not... They pay the bills... so...

Hi all. I've done a search for what I'm trying to achieve below, but there's nothing to give me an idea how I'd go about tackling this. Basically, I have a couple of clients who've asked to show all invoice activity on a daily basis, when I'm sending out monthly invoices. I can do the running...

Glaxiom. Thank you. I've been trying all sorts, and the solution was much more simple. That makes much more sense. Once again, thank you!"!

Morning all. I have a Main form "frmREPORTS" and within it contains a sub form control "SFControl". I'm using a subform control so I can call its recordsource through VBA to view various continuous forms from within the same space, depending on what form the user selects. Here's the...

Arne & Sneu, thank you! Both worked. Sneu, I was on the right track originally, and I had something quite similar I was working on... but would have taken me a week to get there. Arne, I didn't think of using a 'D' - function. Seems I always thought it would achieve the opposite of what I was...

Hi all. o/ Bit of a difficult one to explain (I think). However... I have a theory on how I can get around this, but was wondering if anyone had any advice on a way that's easier. I have a very simple Union Query which lists all entries in a couple of tables for meeting room bookings...

Form failed after win 10 update yet worked fine on a laptop running windows 10 without update and running Off' 2016. Rolled back the update on the machine it failed on and worked fine again. Rightly or wrongly, I've think it was an error with the windows update itself. I know Off' 2016 is buggy...

Well, definitely no other functions called Date, and only reference the date itself across the whole project so I know I'm good there Allan. Message box gives me the same error Sneu and on any other new form I create. Sadly no go Unc on the .value. So I tried the same form on my laptop and...

Hi all. I've been racking my brain for this for the last couple of hours... A simple function to find the first day of this month when a form opens..i.e me.txtstartdate = dateserial(year(date),Month(date),1) Should work fine, and it does on another form that was written pre anniversary update...

Hi all. I'm using the following on a Click event to load a real time tooltip showing details where there is more than one entry on a related table... Dim strSQL As String Dim dbsmyaccounts As DAO.Database Dim rstSplits As DAO.Recordset If Me.Part <> "Split : Multiple Parts" Then Exit...

Hi JDraw. Thanks for the fast reply. Like I say I was only thinking hypothetically, but would be able to utilise it in some sort of way. So I'd have on a form a combobox and have the combobox look in two fields as the user started typing, so if the user only know the abbreviated code of a...

Hi all. Is it possible to have a combo box look in two different fields in a table, to return the same data based on PK? I'm only talking hypothetically as the systems we use for work incorporate this method and it makes for easier data entry, but I'm stumped as to how this would work, based on...

I guess knowing what to find helps in the first instance. This is exactly what I was looking for! Thanks CJ. perfect.

Hi all. Test rolling out a database on mobile devices (namely Surfaces'). To get that 'tablet' effect, Access is running on full screen. Anyway, one problem I've stumbled across Is... without a detachable keyboard, there's no way to get access to the keyboard button in the taskbar of windows...

Linq. Thank you. This is exactly what's been happening. Now.. works perfect every time. thank you thank you!

An odd title. However, I have an issue and was wondering if any others have had a similar problem. When I'm running VBA not using a Break Point, to generate a random long number (based on date and number of entries) that needs to be inserted in a field in the table, using a loop statement, it...

Hi PB, yes it was a form module. everything works perfectly as it should. I've not got so far as a standard module yet. I'll cross that bridge when I get to it, which in fact, I may have well just crashed upon. thanks for your reply. sorry about mine being so late.

It's ok.. I omitted "NewData, Response" in the call handler.

I need some help with something I'm obviously doing wrong... I have several forms where the user can input supplier details (which use the same table) so I'm trying to use a public function to do this. However when I call the code, I get an "Argument Not Optional" message. The public sub...

I have a date field, that can be changed via "+/-" keys on the numeric key pad by increments of either plus or minus one day. Because data within the field physically wont change by typing a new value, is there any way of forcing the before update event to fire if it's changed? Am I right in...