Search results

Hi, I inherited this quote and trying to enhance it but having problem. The filter in navigation form is not working but it is on its own form, the filter is working without problem. Would greatly appreciate any help.

Hi, I've quite a number of report that i'll output daily. Instead of coding it one by one in VB, how can I maintain a table on the report name and output them according to what has been added to the table?

Hi, How can I stop user from closing the form if the mantory fields are not filled up? I try using gotocontrol but it is not working.

Hi, I'm having problem whenever I try to input a record to access DB. It automatically change the language toolbar to chinese. Please help!!

Hi, We migrated on DB to a shared network drive. But the users cannot open the DB. It keep give an error message that microsoft access can't find the database file. Please advise.

Hi, One of my user is getting this error when trying to launch the DB - "Could not use 'admin'. File already in use. The DB is in shared mode and other users are using it without problem. What could be the issue? Thanks,

Hi, I've a unbound combox field in main form, which upon select the subform should display the information. I tried this code but it gives me an error : Dim strSQLSF As String strSQLSF = " SELECT * FROM UT_table_EOM_UT " strSQLSF = strSQLSF & " WHERE UT_Table_EOM_UT.Expr7 = '" &...

Hi, How can I get a 2 digit month when I use month(now())? I've getting only 1 instead of 01. Please advise.

Hi, Currently I have a remark field and want to just extract the amount. The data input is not in a structured manner therefore I could not use the mid function. Appreciate some advise. Example : Remark CASH PURCHASE $50K.DEBIT 3007484701...

Hi, I'm trying to publish the access db over the web. How do I get the security portion? I'm currently using the access security.

Hi, currently I have a table A (2 fields, Name and Signature). How can I insert the signature upon a click of a button. Meaning, in form A (the link is by name to table A), when the user click approve, their signature will be inserted. Cheers,

Hi, I've the following code but the cancel doesn't seem to be working, when upon click cancel, it should still remain on the form but it closed the form. Can someone please advise. Dim strMsg As String Dim strMsg2 As String Dim strTitle As String...

Hi, How can I do the following : I've a name field which I would like to extract part of the information. For e.g Tom Cat Dog, how can I extract just the initate, C from Cat and D from Dog so that my name will appear Tom C D Thanks,

Hi, Currently I've one txt file that contains a few reports, I need to break them up but grouping the same report into one file. This is how the txt file look like : I want to have all with reportid 001 into one file and 002 into another. Please help. ReportID:001 aaaaaaaaaaaaaaaaaaaa...

Hi, In Access 97, I'm able to use Database but Access 2000 is giving me problem. Please advise. Dim MyDB As Database, MySet As Recordset Set MyDB = DBEngine.Workspaces(0).Databases(0) Set MySet = MyDB.OpenRecordset("Sorts", DB_OPEN_DYNASET) ' Create dynaset. Regards,

Hi, I'll rename a folder call daily to system date but sometimes it is in use by the user and thus fail to rename, how can I wait until the file is not in use and then rename it? Please help. Tks!

Hi, I have the following files : 1_20030704_file1.dat 2_20030803_file2.dat I want to do a global rename as the file name is not fix. In dos I can do ren *.old but how can I do it using MSAcess. Tks,

Pull query by month Hi, I currently have a date field and I want to pull out base by month, every month I need to report data as of the ending month. For example today is 09-Apr-03 and I want all records that is ending month of 31-Mar-03. How can I do this automatically? When I use the...

Hi, I help to do the following: I need to monitor for a file in G:\test.pdf. If the file is there then copy if to C:\test.pdf. If the file is not there is will wait till it is there then copy to C:\. How can this be done? Thanks.

I have 2 table how can I delete records which is found in table 2.