Search results

autonumber should never be used for personal reasons, its for access only. Its not editable and it can't be relied upon. You MUST use a number field if you require to keep a sequence. It's fairly straight forward to implement, with a query or VBA: 'adding a new record TheID =...

I can't seem to open it (perhaps it's because I'm still in 2007)... I would check the set up of the combo box. What is the bound column? If it refers to an ID (i.e. the information that is stored from the combobox) then LB will need to be Long type not string.

Ah :) LB should be a string type, not combobox type. You've also called it LG instead of LB Also i'm not sure if it would help, but try LB = Me.[comloggedby].value as well.

can you show us the code that you are using to retrieve the value of the combo box? It sounds like you are referring to the value rather than the field...

I would approach it using: For i = 1 To 100 'code Next i This creates 100 instances of i and repeats the code using the variable. Coupled with INSERT SQL queries, it should be doable... You could, for example, in an onclick event: (untested) Dim BN As Long 'Box Number Dim TheSQL As String...

I was having trouble just setting each report with a particular print method - for some reason they just kept forgetting their individual settings and resorting to default on the machine. This meant reports were printing on the wrong paper, or the wrong size paper, the wrong orientation and...

pr(pName) - didn't work JHB, and neither did pr.Fields(3) namliam... However, if I combined the two, I got pr.Fields(prName) ... and now it does :D Maybe you two should become crime solving partners...

I am trying to create a function which will use variables to extract which fields are needed from an SQL statement and therefore retrieved via OpenRecordSet. Public Function DoSomething(pName As String) Dim PrtSthg As String Dim pr As DAO.Recordset Dim tray As String PrtSthg = "SELECT ID...

CurrentDB is useful, but only when a path is already established. I need it to find what network is available on the system, and that will tell it what branch we are in. If I used it on the front end, I would have to name every computer on the network... I can't point to the backend because...

At the moment it's in 3 basic steps, - Establish which branch the database is - Determine what the path is for the back end - reconnect to backend the method I am doing at the moment is using the different paths for the backend location to determine where the database is. I could just check...

I like to create dummy SQLs using a query builder, then view as SQL, and change the names to the relevant variables...

I am using the "folderexists" function to determine the location of the backend. This is followed by tableDef functions to relink the database with the backend. the folderExists function is a custom function I found on google, and it works but makes start up incredibly delayed. If...

I am creating a colour coded check list for pending invoices, I have made a continuous form, and placed a box behind. The box will become a different colour depending on the status of the invoice If IsNull(Me.Total_Due) Then 'Invoice is still open e.g. unfinished Me.BackBox.BackColor =...

Hi guys, I've developed an invoice tool which I've made 100% automatic and fool proof. All known errors are captured and dealt with, all forms are polished, all I's dotted and T's crossed... There is just one thing I can't make automatic... installing the database across the 3 sites which use...

Thanks guys! Yes - it was an issue with Form_Current() - I assumed I needed it because a new form page was being navigated to. I will look into data entry and keep my code concise. Thanks!!

urm, yeah... I've been tackling with a form for a while and kept coming up with a "cannot go to specific record" error... I decided to check in the tables to start again - and it turns out it adds nearly 1,000 blank records before giving me the error. - so after deleting nearly 100,000 blank...

Ah - apologies... I realise I never declared 'ResultCount' hence the zero... one moment, let me try something...

Thanks Eugin, That solved my missing operator conundrum, but it's telling me there are 0 rows? ID Date Paid 1 21/01/2013 12:18:17 2 21/01/2013 12:20:20 3 21/01/2013 13:05:41 4 21/01/2013 15:24:56 5 23/01/2013 09:36:25 6 23/01/2013 10:25:02 7 23/01/2013 14:32:31 8 29/01/2013 15:14:12...

I am trying to add up a list of dates that match a criteria... a search box result. I have tried DCount, and now I'm doing it through SQL, and no matter what combinations I try I still get an error - usually 3075 - Syntax error (missing operator) But I can't find anything missing - I copy the...

I was searching the internet for the best way to add 'smart' navigation, and I thought I'd share my make-shift solution. Apparently it's not very obvious? I am talking about the "first" and "last" and "next" and "previous" buttons which annoyingly will go to a new record if it's the end of...