Search results

hi all thanks very much, because i've seen the error, it was due to lack of a trailing back slash in my sSourcepath i replaced: sSourcePath = CurrentProject.Path with sSourcePath = CurrentProject.Path & "\" and it was perfect. thank you all

I tried putting some error handler but still the same response, maybe you guys can try it as the can be in any application unaltered. Function BACKUPS() On Error GoTo Err_BACKUPS Dim fso As Object Dim sSourcePath As String Dim sSourceFile As String Dim sBackupPath As String Dim sBackupFile...

Thank you all for the advise, I'll try it.

Hi all i tried creating a backup code with vba, but i get this message "FILE NOT FOUND", this is confusing as i feel i've put everything in place. This my code: Function BACKUPS() Dim fso As Object Dim sSourcePath As String Dim sSourceFile As String Dim sBackupPath As String Dim...

Thanks for that, anytime a user logs in the username is displayed in Forms!PASSWORDS!Text43.Value, and i want the username to be checked if it exists in the Authorisation table before allowing the user to do a certain thing. thanks and i appreciate your response.

please i have an issue with my dlookup, i want my dlookup to run through a table and check if a name exist in the table before carrying out and action, but it seems to be working on one name at a time and it won't work on another name except i remove the first name from the table, then another...

Hi, I have a table but the table is not showing the values inserted from a combo box, but the values show when i create a query based on the same table. what can i do? thanks

Thanks, I finally got it to work, it was my filtering method that was wrong.

Thanks, but it still not working keeps telling me "datatype mismatch" But d duedate column is a calculated field.

Hi, Please i got stucked in this, i have a table with many columns. one of the columns contains due date for payments. what i want it is for a form to open displaying/listing the due paymets alone when i click a command button. I'll appreciate this. Thanka

thanks for the idea

Please i want my report to display the Print Ribbon when my report is in "Report View mode", it only shows when it is in "Print Preview mode" please any help'll do thanks

Please i want have a form where all users who login and log out can be seen and the timing of their logging. It's important thanks

the usernames and passwords are not system's so i need to make sure the usernames goes into a table against every record entered, so that for every record entered you can get the person who entered the record. that is my challenge. thanks all

in order for me to be able to display the username on my forms, i created a textbox on my login in form with =[Combo22].[column](1) as the control source. when a user logs in the password is correct the swithboard opens and the login form goes into hiding so that all the forms will continue to...

i don't use ULS because i use access 2007, what i did was to create a table for usernames and passwords and i use dlookup to lookup the password against the username and it's working.

this is what i used =[Forms]![PASSWORDS].[txtemployeename] the form "passwords" is hidden not closed so the me.txtusername text box on my forms refer to it. but now using this as the default value in a table is not working. can you give me another idea thanks

my database displays the username on the forms, but i want the username of the person who is entering a data to be inserted in the table where the data is being entered, so that when you look at a record, you can know the user that entered it. for audit purpose. thanks any help will do

thanks for that it's cool

Please how can i stop compiling, because when i need to compile another code i discover that the compile button is disabled....any help thanks