Search results

Or that should be 2 files, one is for records after month end process and the other is before month end processs!!??

In ACCESS 2003, I have created query and then sub-form based on that query. The query may retrieve records which contain monthly records of which I do not want end-users can delete records after official monthly ended process. However, records still can be deleted if they belonged to period of...

I got a FE and BE relationship!! Just want to know which PC should I upgrade will run faster than before as a result, if I can only upgrade one of them?? Thanks a lot!!

How to use barcode gun to scan barcode to ACCESS and then converted to alphenumeric data which can be understood by ACCESS?? Thanks !!

Sorry! Paul, I am asking the consequence but not how to solve it !! Thanks!

Step 1 - Paste the function below into a VBA Module. Step 2 - In your Reports, create a Text Box with the dimensions you want the barcode to fill. Step 3 - Set the Text Box's Visible Property to No. STEP 4 - In the Report Detail's On Print Event, add Result = Barcode_39(Me!MyTextBox, Me)...

WHen I unzipped the file, it got 2 font files, fre3of9x.ttf and free3of9.ttf, which one should I need?? Thanks!!

It's pity that some filenames and field names are in chinese though VBA are still in English. If I am luck that you all can open the database, please click the WORKSQUARE to trigger the form/subform, in the middle of the subform (the first YES/NO column), if you click the YES/NO , the warning...

I got a doubt as follows: No matter it is using ADDNEW or EDIT in recordset, values are assigned to different fields but before doing the UPDATE action, if I assigned those fields to another variables. Those fields content would also be assigned to those variable or only can those fields got...

MY database is a Chinese version. I am not sure whether this is the problem, let me try my best to explain further. FIrstly, I got a form/subform relationship with a combo box choosing invoice number for subform to display records belonged to that invoice. In the subform recordset, I got a...

I have changed the statement to Set TRANS2 = Me.RecordsetClone, but the effect is the same as before. Do I still miss something?? Thanks!

Thanks Galaxiom. Option 2 is not result that I want. In fact, I don't know how to do the option 1 automatically using VBA, but only manually by user input! Option 3 may be but I still don't fully get the idea nor skill to finish after wondering many posts in this stie! Just want to know if I...

Sorry both gentlemen! I had overlooked Uncle's command! I supposed it meant to search the font instead of storing the font!! Sorry about that!!

I still don't have any idea to fix it! Any further idea?? Thanks!

MY PC doesn't have Fonts directory under Control Panel!

Yes! Manually change did not have any problem!!

Is there any way or statement should as MSGBOX to tell which user had opened the table or recordset?? I don't think other user can link to my database for the time being! Is that, the Main form had a link with the subform which meant when all record displayed is a sense of user opened those...

Firstly, I had used update query to work but I found out the same problem appeared. Then I switched to use rescordset and the same still pretained! My doubt is why it kept on saying the recorded had been opened by other users but in face, I was the only user to work with all the database for the...

Sorry ! Typing mistake! It should be MOVE.NEXT in my VBA!!

Sorry Uncle, I meant I could download the font, but don't know which location in my PC should I have to store it and unzipped it !!