Search results

Hope you don't mind my having a go as well :) I did get it working after some experimenting but I am no expert so don't take this as a solution. I believe the issue is Volume drives that do not exist on a system and will give a runtime error 52 before failing. I can only assume that the DIR...

I think this may be something to do with 32x and 64x OS's, I have experienced anomalies before when switching between the two. I have a demo invoicing db with the tables and code combined and yet the invoice popup would not show on a 64x. I also have tried to combine an FE and BE (from a 64x...

I have a form with a similar setup, what I did was click a button to close the form and then open it again which will start it afresh. DoCmd.Close DoCmd.OpenForm "Frm_SearchAreas"

I took on a client db a few months ago and immediately saw a size issue they had, I produced an image (sensitive data blurred out) to show what would happen in 6 - 8 weeks time if they carried on at the same rate. Just to mention also that you cannot have referential integrity between tables in...

Try adding this clause DatePart("yyyy",[ContractDate])=DatePart("yyyy",Date())but will you need to show contracts that are for the next year if you run the query in later months?

From what I've looked into, environment variables don't work well with the File:/// URI. However you can send individual emails by using a recordset, you just need a table containing the pc usernames and then build up the hyperlink using those usernames.

What does it show for the Column Count for that combo box? It will tell you within the Format tab of the Property Sheet (assuming AC 2007)

It looks like you have a trailing ',' in this line "[Country].[icUpdateRDO] = ," & _ It should be "[Country].[icUpdateRDO] = " & _ don't forget to include Galaxioms bit as well though

I will expand on my last reply by example Your file path looks like it's on a shared folder named Desktop but it looks like your missed off the server name (or the name of your pc). Or it could be that your pc is called Desktop and you missed off the shared folder name. On my pc it would be...

It could be an issue with network files or permissions on them, I would try your code with a local copy of the db file just to iron out that possibility. Come to think of it I would normally expect a share file path to be \\server\foldername\filename.ext

I believe I got this working but only in Outlook, are you using a different client?

I think I'd rather answer BlueIshDan's question But seriously you are looking at stock control from an idealistic point of view rather than a practial one. The convention is that you should calculate values from tables rather than store them.

I ploughed through a couple of ebooks and the nearest thing to deleting a relationship was this bit of code 'Check if the relationship already exists. 'If so, delete it. If IsObject(dbs.Relations(strRelName)) Then dbs.Relations.Delete strRelName End If I havn't practiced any of this...

I believe you will need to use a parameterised query using QueryDef for this to work in a recordset. Add the following. Dim qd As DAO.QueryDef Set qd = db.QueryDefs("TestLocationQuery") qd("[Forms]![LabScheduleForm]![TRNumberCombo]") = [Forms]![LabScheduleForm]![TRNumberCombo] Set rs =...

This got me thinking away, so if the date is not constant then the formula must be along the lines of =Clng(Date()) Mod 7 which for today 11/05/2015 will give 2 (or the 2nd day of the week) so the offset is needed to realign the day depending of whether the 2nd day of the week is a Monday or...

I did read about hidden forms elsewhere but without an explanation, it's all clever stuff.

It even worked on my WinXP VM, however I am looking to build databases for clients and don't want to implement anything that I either don't understand or that might be risky which makes regedit a no-go area. I do have a URL builder that opens in chrome but I guess if someone wants it in a form...

This happend to me only a couple of days ago although I was using a VM with WinXP which had IE8 so prob no wonder it didn't like it. I gave up on form embedded maps as the google puts a warning about the compatability view which apparently cannot be turned off unless you wanna fiddle with the...

Thanks for explaining, I have looked more closely when debugging and can see how DoEvents and acDialog effectlively halt the code in the subforms whereas without either it processes all the events code instead. So my next question is why Solo712 uses both DoEvents and acDialog in his code...

Can I ask why it's done this way (I am still on the learning path), I think I emulated the scenario more or less. I have a main form with 2 subs and a popup, both subs have an On Click event opening the popup and the popup returns a value to populate a textbox on each sub. I have found that...