Search results

Why are you trying to manually create an autonumber when Access has the functionality to do this automatically? Regardless, try something like this: Private Sub Form_Current() 'Open virtual recordset dim db as database dim rst as recordset set db = CurrentDB set rst =...

Alter the strSQL code as follows: strSQL = "SELECT tblTrainingContacts.TrainingID, Contacts.[E-mail Address], " & _ " tblTrainingContacts.Confirmed FROM Contacts INNER JOIN tblTrainingContacts " & _ " ON Contacts.ID = tblTrainingContacts.ContactID WHERE " & _ "...

I use code like this, combined with comboboxes to select the output (reports, exports, etc), to allow the user filter their choice of reports dynamically with none of the risks associated with users creating their own queries. Very useful code, it lets you filter on as many fields as you want...

What changes were you making? It looks like a generic error message stating that you have entered an invalid input in a property (the example being a bogus event property), but without knowing what you have been inputting into what property it's hard to know exactly what went wrong. :edit...

.Name worked perfectly, thanks. After getting home yesterday I realised I had working code within my audit trail function in another database so had this not worked I would have checked that and posted the solution.

No error message. It does go into the If statement, so it decides that the criteria for the If statement has been met. I tried adding "msgbox ctl.ControlName" into the process which is not included here, expecting to get as many message boxes as I have control names in the If statement...

I have a piece of code which uses For Each Control to loop through a piece of code for each control on my form. However, I want to be able to limit it to certain controls on the form now. Worst comes to worst I'll stick the code in a module and pass the control name to the function but I'd...

An input box cannot mask the entry (a 3rd party add-on may alter this). If I wanted input box functionality with an input mask I'd create a simple form with 1 textbox and 2 command prompts and make it look like a generic input box. Instead of going from the main form to this restricted form...

I'm tempted to get this: http://www.amazon.co.uk/gp/product/B003XFUXQK It's not drive bays, but the hard drive is just a USB hard drive placed in the dock which makes it accessable via ethernet so if I bought a newer one to upgrade the old one could be a second NAS or an external hard drive...

Picking one of the lower spec ones at random (TS-219P II) the audio streaming is advertised as working with iOS devices, but the video streaming isn't. Perhaps I should look into the hardware required to convert files, I have heard that some NAS boxes are powerful enough to provide live...

To confirm, I have a PC but the point is that I don't want it to be turned on 24/7 to stream media when I could have a less power-intensive NAS drive doing the same thing. I'm prefectly happy to interact with it using my PC and I expect it to stream to my PC (which I didn't mention as any NAs...

I'm actually considering dropping the first requirement given how much cheaper the ones with built in hard drives are compared to the ones with accessible drive bays. Which leaves me looking for NAS drives which are usable with xbox 360, ipad & android without a PC converting files / running...

I'm currently looking for a NAS drive for use a sa media server, but since I have a few requirements I thought I'd make a post here to see if anyone knows of one which suits me rather than me flicking through pages and pages of technical specs and forums to check the compatibility of each one...

Sounds like a cross tab query may give what you want (i.e. staff names = column, 15 min interval = row, booked appointments = data) but I'll let someone who uses them come in and explain more (I don't really use them myself). In the meantime you could play with the crosstab query wizard to see...

A database is simple to create. A database that does everything that you want is less simple. The simple fact that you are here asking for help rather than doing it yourself shows how complex it is for someone who doesn't build them for a living. However, if you want to do it yourself...

You don't start with data processing, you start with data storage. Before you can decide how to manipulate the data you need to know what tables you will have and what fields they will contain. Without that how can you plan how the data will be edited when a customer arrives for their...

I would assume your reciepts would be reports, they are the most printer / email friendly ways of presenting data on a transaction imo. I regularly use reports for things like invoices as well as normal reporting purposes. Unless you are trying to do complex things you can get by with no...

Replace the ; with a , I've not referred to a form control on a report but I see no reason why it shouldn't work, as long as the form is open.

If you want to display the result of an NZ function applied to a field then you can use the field which has had it applied to as the control source of a textbox. Alternatively if the field in the query has not had the NZ applied you can apply it in the control source of the textbox like this...

So you have 19 indexes which don't allow duplicates and 24 which do and you think the max is 32? 19 + 24 = 43 43 > 32