Search results

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...

Attached an example. I would like to create a filter which contain the employee name from the report. In the example I have 4 employee but only 3 of them have task, so the combo box will contain just 3 employee

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...

Thanks i will try it

Thank you all I solve the problem. at the switchboard i create if condition CheckTime = format(now(),"Short time") if CheckTime = "20:00" then docmd.openForm "" end if

Thanks, I have a code that log off users on demand which I used in Form_Timer().this is on switchboard is there a way to compare the current time to lets say 22:00 and if it equal then activate that procedure? Basically What I need is the update the users table and the timer will be activated...

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 Again I still don't get it gow can I display or seperate just the file name for display purpose Dim f As Object Dim strDocumentFileName As String Dim varItem As Variant Set f = Application.FileDialog(3) f.AllowMultiSelect = False If f.Show Then For Each...

if you are not using Hyperlink data type what is the best way to work with in VBA?

Great the path and the file name is working but when the textbox show me the link it looks like I can click on it since the textbox bind to hyperlink in the table. But when I am trying to click it doesn't do anything for example after I load 1.xlsx to the textbox I can see c:\1.xlsx but when I...

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...

Great Thanks

Ok sorry about that. I have few forms and I would like to create a menu that every button open a speific form

Hello I would like to create a form with 3 or more sub forms I don't want to use the control tab since it has few problems Any ideas? maybe an database example? Thanks

what do you mean by join them?

Yes I meant that when trere are 6 tasks, one task is in low priority, 3 tasks is mediium priority and 2 tasks is in high priority what do you mean create another crosstab? how can I join 2 crosstabs in a form?

Ok I got it the only thing I added is iCount = DCount("*", "Task", "title LIKE '*''''*' and task_id=" & me.id) but I forgot to add it inside the loop. now it is working thanks

Well I tried that' it doesn't work well. it gives me an erroe message for the update query about the icount can you please send me you db that you created? I would like to see how ir works for you regards

in my database I hace a table with tasks,employee and priority for every task. I would like to sum them for every employee, is it possible?

anyone?