Search results

Hi, a lot depends on what you use to download data. What would be the input dataset:Excel, CSV,... ? Then, since you say that the "dummy" key - manually inserted, I assume - will identify the job and the customer (youself that is), it should be a cinch to filter it and append the relevant...

Good for you Colin. I don't think you are getting it, though. It does not matter one whit how many clients the app has or how many paths to the BE they have. As long as each workstation at each location has a way to find its own path to the BE (independent of the FE current links) what I have...

I have developed a variation of this which handles this slightly differently. I just leave whatever BE reference there is in the new FE. When the new FE runs, and the reference to BE is incorrect, it will cough up Error 3044 (Invalid Path). Since you need to test a "network down" situation...

You are welcome.

Be it as it may, your code will not fix anything - in theory or otherwise. This is just bad design that needs to be fixed. Period. You can easily rewrite the dropdown box to show month and year. Say something on a twelve-month rotation like this: Private Sub PrepareMthList() Dim tdate As...

I am sorry but I don't understand your issue. The MonthAdd function adds the same way all year round, and handles the year rollover. January and February do not need special logic. You say the billing month is the month following the invoice. So, if the invoices are late a month, the billing...

Hi, basically you are looking at two different external tables. One is employee wage history, as Ranman suggests, and the other is Employee Attendance/Absence which tracks vacations, leaves, sick days, etc. Both tables would have the employee ID as the foreign key. Trying to figure out why...

The trick I am using is this: Create a boolean variable that is visible by the whole form, say StopUntilSaved. In the Form_Current event set it to True. Then place this as first statements in you Form_BeforeUpdate event: If StopUntilSaved Then Cancel = True Exit sub End If Finally...

Thanks, Pat. You are right about fixed price pain; it is always a moving target. Unfortunately, for me I don't have an option on certain type of contracts, that is mostly on building turnkey systems. Since I invested quite a bit in a RAD code library that allows me to build apps quickly and...

Hi everyone, In my experience as a freelance software developer, the biggest obstacle in running the business has been to get paid for my products, even from people who expressed satisfaction with what I delivered to them. In the eighties I eventually gave up and got a “regular job” in IT. At...

You can use this: if myDate = WeekDayinMonth("2nd Tuesday", myMonth, myYear) Then ...... ElseIf myDate = WeekDayinMonth("4th Tuesday", myMonth, myYear) Then ...... End If...

I take it you mean 'storage replication' rather than 'server mirroring'. I am not aware Microsoft has server mirroring capability; actually I believe the idea of mirroring networked servers went out of fashion after the catastrophic SFT technology by Novell. Microsoft has committed to...

You need to make sure that the access to the Timer event is restricted to copy the new front end only once. The best way to handle this is to have a small update table on both the Front- and Back ends. The users' front end would check if they are updated to the last available version (by...

It should be pointed out that this routine will work only if the recordset is ordered by a field which appends the record as the last member of the recordset. I would do this instead: dim rs as dao.recordset set rs=me.recordsetclone set rs=rs.openrecordset if not (rs.BOF and rs.EOF) Then...

Hi , I don't think anything would be bulletproof here but I would make that "pointer" table Minty suggested a "Usys" table and hide it in the navigation panel. Best, Jiri

Basically the same goes for Canada; you need to get the deductions-at-source formulas (tax, pension plan, employment insurance) approved by the Canada Revenue Agency. They were giving me grief over 12 cents difference on a formula calculated tax, even though if I used their approved manual...

Hi, ryetee You don't need to close anything. With VBA, simply copy the database and do the the compacting on the copy. Then rename the compacted copy when you are satisfied everything is ok. I do this for both the front- and the back- end. Works like a charm on 2007, 2010, 2013. Here is the...

Strange but true...I tested it and it was stopping at runtime 3075 errors if there were files or folders with apostrophes. I tried Browne's original code with the SELECT clause but it wasn't able to read those files either....it just marked them as errors....though there were no interruptions...

Ok, you may want to try this old trick to see if the apostrophes are your problem change the line strTemp = Dir(strFolder & strFileSpec) to this strTemp = Replace(Dir(strFolder & strFileSpec), "'", "''") Best, Jiri

Hello hubelea, My apologies for the earlier post. I felt sure I was looking at an object. At any rate, I went back and fixed the routine. Took a while to figure out but there was a problem with the code posted in the OP. (Was that the original code by Allen?) The errors were generated by the...