Search results

Hi I have a form , on the form I have few textbox and I would like to add images that I copy from printscreen or snipping tool and paste it to access. I don't want to save the image on the database access. I would like the access open paint or word or some other app so it will paste the image...

Hi I have a form with 3 fields. 2 fields in component date and another field with textbox (integer type) At the first date field I am choosing the date. I would like to calculate the date + text box and insert it to the second date for example date1: "01-aug-2024' textbox = 5 i would like to...

Hi I have a tasks table with status, dates (first date and end date). and more fileds I would like to create a Gantt chart for me tasks. the gantt chart will be something like at the image. Does anyone have an idea or an example for that? thanks

Hi I have a continuous forms with some data which mea, ii display all data I have at the details the data is (id, detail and date i would like to click on one of the record and mark it or change the background can someone please help me with that

Hi I have a code that search on a table a record, set rs=db.OpenRecordset("select fname from employee where id = 5" ) and i would like to use the if statement: if rs("fname") = "cccc" then....else.... the problem is since my table doesn't have id=5, I get an error message "invalid use of null"...

Hi I have a form with list box. At the list box I have just description. At the main table I have sorting field also I would like to give the user the option the change the sorting records, something like drag the record or move with button control Is anyone have solution for me please Thanks

Hi I have a code that hide the navigation pane (workd great)> The problem is in form, when I click Right Click on the tab it let the users edit the form. how can I disable the right click menu? Docmd.ShowToolBar "Ribbon", acToolBarNo docmd.NavigationTo("acNavigationCategoryObjectType")...

Hi I have a table called ImportEmailsTBL with id, SubjectMail, MSgBody. at outlook: I save my emails to a folder called - TempEmail I would like to scan the folder and import every email to my table (ImportEmailsTBL), the subject of the email will go SubjectMail Field and the body of the maill...

Hi I have a form with 4 boolean field (mark yes no) called team1,team2,team3,team4 is there away to mark the boxes in vba in a loop ? for example instead of me.team1 = 1 me.team2 = 1 me.team3 = 1 me.team4 = 1 to do something like (this is now working) for i = 1 to 4 me.team(i) = 1 next i Thanks

Hi I would like to create a form with RichText textbox because of the font design . I would like to have toolbar that stay always at the top something like Microsft-word is there away to do it?

Hi I created a form with textbox called "task" which is in HTML template. When I click on the save button it save at the databse with HTML tags. I would like to create a combox with the task field so in the source field I chose the table. The problem is the combo box display the HTML tags is...

Hi I have 2 navigation buttons.at the first navigation i have a torm with save button called SaveForm I would like to click on the second navigationbutton and it will active the button SaveForm which is in the first button, how can i do it?

Hi I have a form with few bounded fields. I created a click event on one of the textbox field, when I click on it I see the description something like MsgBox "you ID is " & me.idSubTask that works fine when I add an image component and create the same code it doesn't work. what I want is to...

Hi I have a form that insert and update some tables. I would like to insert and update to more than 1 database for backup purposes I don't want to create a scheduler that copy the database to another folder since I am working in a big company and it takes to much to do it is there a way to do it?

Hi I have a table with 3 fields (id,Task_id,description) and the values looks like id task_id description -------------------------- 1 1444 aaaaaa 2 1444 bbbbb 3 1555 cccc I would like to create a form with 3 unbound textbox and fill the textbox something like dim rs as recordset dim db...

Hi I have a form with 4 navigation button. at navigationButton109 I have a button component , when I click on it I create an event that make visible the other navigation whcih works great [forms]![TaskNavigation]![NavigationButton113].visible = true the problem is I would like to make this...

Hello I have a split database shared over a network. From time to time some users get an error message "Microsoft Access has detected that this database is in an inconsistent state’. When you click OK in the error message window “The database ‘xxx.mdb’ can’t be repaired or it is not a Microsoft...

Hi I have a TASKS and EMPLOYEE tables wich connected like task.employeeID = Employee.id. I created a query that join those tables together. I would like to create a form that display all query data and combo box of the employees. The form will filter the data as I select the ceratin emplyee...

Hi I have few users that login at the same time and from some reason at the next day sometimes I get an error message about database so I thought of force the users to log off after 8 o'clock (the hour is just an example) . Anyone have an idea how do I do it? Thanks

Hi I would like to create a form with upload file option. the uploda include browse option. everytime I click on the browse it should open a dialog box. which mean it should add the record to the table and for that I create a table with id and links fields I found a code below that open a...