Search results

This could ba simple select statement. ComboBox1 Properties Row Source Type = Table/Query Row Source = SELECT DISTINCT [Load] FROM tbl1 ORDER BY [Load]

You can check to see which item is selected. Then keep track of the first item and loop through the list. Also keep track of the rest that are selected. At the end, just do a insert/update to change these records in the table. lstName below link to a table tblName (ID, Name) Private Sub...

Once it's in the second back end, I would probably then append a chunk of records at a time to the production BE database.

May not be the best solution, but it's a suggestion. I did something similar in that nature in the past. Since I didn't have much control over third part software, what I ended up doing is create a small application that would shut down any application specified in a text file. This small...

The record locks some how links to the delays between the person's pc and the server. In addition, since there will be 10-40 people using the application simultaneously, by using classes, I was able to establish connections to the BE, perform what needs to be done, and then close the...

This may not be the correct way to do it, but it appears to work for my application. Form Cycle Propert = Current Record See attachment. EZ

Good point, DCrack. That could very well be my issue. After I modified my code based on Boblarson's suggestion, I still get the same error. Since our server (where BE is stored) is collocated, we do notice the performance delay. Per your suggestion above, how would I go about slowing down...

Thanks, Boblarson. The characters seem to be normal. I'll set it to lock at record level and see what happen. It also appear that the text in the Note field are less than 255 characters so I'll change it to a text field and see if that help as well. I'll will update the forum later today.

That is correct. I have the FE on all of the users' desktops, the BE is on a network drive. And Yes, I do have one memo field on the Main form. Would that memo field the the reason for causing this lock-up?

Can you actually run that particular application from the location where this access databae is pointing to?

Issue: Run-time error '-2147352567 (80020009)' Could not update; currently locked. ------------------------------------------------------------ I have a simple database that are being used by 5-10 users. (FE (mde)/BE) Very often, users get the error above and I am not getting why this error...

Thank you The Doc Man, I'll take that approach. -ezfriend

Hi All, How can I programmatically detect if a mdb file contains forms? I know the easy way just like most people (open & look), but for this purpose, it will take half of my life time to go through all of these dbs. Any advice is greatly appreciate. -ezfriend

Ran Windows update and that fixed it. I realized that this happen right after I install Youtube Downloader so that could have been it. Youtube Downloader does use the same MSCOMCTL.OCX. At least I found it in the same folder where Youtube Downloader was installed. :)

My application uses the ActiveX control (MS ListView 6.0), but recently the application doesn't recognize the ActiveX control anymore. I went and create a test form (new.mdb) and attemp to insert the control, but I realized the that ActiveX Control is no longer an option in the list when you...

ONE SIMPLE TASK 1. I want to capture and active screen (MS Access Form) and paste it into an OLE object (THIS IS DONE). 2. I want to print the OLE (NEED HELP OR SUGGESTION HERE). Is it possible to automate with the press of a button and sent whatever image (screen captured from #1 above) to...

That was a great help. Although I didn't get any errors, after I ran the compile, I was able to create the MDE file in a split second. Thanks a bunch, CraigDolphin. _ez

I am attempt to create a MDE file, but MS Access seems to freeze. The application has db1.mdg (forms, reports, modules) and db1_be.mdb (three tables). Simple database. When I try to run the MDE wizard to create it, MS Access seems to freeze. CPU is running at about 25 (20,068K). Any idea...

Here is the SQL SELECT tblEmployee.EMPLOYEENO, Sum(tblEmployeeHour.NUMHOURS) AS TotalHours FROM tblEmployee INNER JOIN tblEmployeeHour ON tblEmployee.EMPLOYEENO = tblEmployeeHour.EMPLOYEENO GROUP BY tblEmployee.EMPLOYEENO; The results is correct, but when run with the report, it is being loop...

My report record source is set to one of the query that I created. For some reason, when I run the report, the records are being cycle twice which makes my total double what it is suppose to be. The records consist of Employee Number Number of Hours Total Hours (for all employees) Each...