Search results

Customers with multiple, or changing, delivery addresses are an extremely common occurrence. Even if in your case you have only one such customer at the moment, it makes sense to have a separate delivery address table in one-to-many relationship to the customer. This will make for a much more...

Yes, I think Gasman is right and the code below should do it: Set rs = db.OpenRecordset("SELECT * FROM Tbl_Tickets " & _ "WHERE DatePart("yyyy",DateOpened) = " & CmbYear, dbOpenDynaset) Best, Jiri

Hi, try putting brackets in the directory in the path whose name has spaces in it. like \[Root Data 01]\ Best, Jiri

Hi, Usually, the way to deal with different access rights of users, is by having a table with users and their access levels or profiles that give them right to see forms/reports and perform operations. The users log in and their credentials are saved for the session. Then they are referenced...

No, I am not talking about queries in a table but a restricted value list that is being treated as a text box. Kindly read what is being proposed before commenting. Jiri

Hi, one way to fix that would be to have a value list field (combobox) in the table with text for the three conditions that you named i.e. 8 hrs out, 3 hrs, and late for x minutes. Then if you need to convert the values to points for a report/query you may do that the way you constructed the...

If you want to order the combo by LastName instead of ID, display the design of the table, select the combo and then the Lookup tab. On the Lookup tab change the ORDER BY in Source Row to "ORDER BY [LastName]". Best, Jiri

Hi Colin, this is a useful set of utilities. Just as a heads up: the resize form utility does not reset the default screen resolution constants(which are 800 and 600) on exit and as a result the windows screen may lose the start button and taskbar, if the native windows resolution is higher...

Try appending a semi-colon. Print #FileNum, StrBankTransfer; Best, Jiri

Get into the VBA editor on the user's machine. Then pick Tools>References on the menu. I assume each user has their own Front End. The Access Object Library should be for the version of Access on the machine( ie. 12.0 for Access 2007, 15.0 for Access 2010, 16.0 for Access 2013). Best, Jiri

Check if the user has the correct version of Microsoft Access xx.x Object Library. Best, Jiri

Hi, not sure what you want to do with this. In database design, it makes no sense to store the same number in two fields which only differ in numerical notation. The way to do it is to store the number as decimal and use the hex notation as you need, as a function in a query. Best, Jiri

You need to requery the combo box from fom_ClientDetails when saving the new client record. Add the following in red in the Click_Save sub: Else DoCmd.RunCommand acCmdSaveRecord If CurrentProject.AllForms("fom_TaxInv").IsLoaded = True Then Forms!fom_TaxInv!cmb_ClientName.Requery End If...

Right, this is not a good idea. I have never tried it, (nor would I) because "calling" an OnLoad event of another form does not make sense. If the form is already open then re-loading it is redundant, if not then the call would skip the OnOpen event of the form where the form object is set up...

So, you are saying you have run the code and received no VBA error, correct? Best, Jiri

MickJav, have you actually try to run this code? Did you get any error messages? There is at least one glaring error that I see (I did not look further!). The statementF = InStr(Me![WorkingDays], I) should be flagged by the compiler because "I" is defined as integer and both arguments of the...

A simpler way to do it would be :NextFriday = pDate + 8 - Weekday(pDate, vbFriday) Best, Jiri

Ljusha, I am not really sure why you need two tables. Actually you can "solve" your issue simply by formatting the hours portion of the field. The join as you wrote the query only serves as a way to restrict the time of the order to only a set of selected values. I don't know why you did that so...

So it was, PerfMon first, but when I pointed out some issues with it, now you are into Task Manager. Ok. I see. Are you talking about Task Manager on a Windows Server by any chance, are you? I had an impression Khalil was using workstation hardware and OS. Incidentally, the OP mentions that...

I don't find PerfMon a useful tool. It's difficult to configure to get anything of value out of it, it's buggy and breaks down easily; besides it is known to cause high CPU utilization itself. AFAIK, none of the easily available monitoring tools will give you what you would need to do a real...