Search results

You may have luck with a UNION query Just remember to terminate the end of the query with a semicolon. SELECT acct, value1 FROM YourTable UNION SELECT acct, value2 FROM YourTable UNION SELECT acct, value3 FROM YourTable UNION SELECT acct, value4 FROM YourTable; After that, I would follow...

Oh, i just read somewhere else someone mentioned that a msgbox could be system modal.. maybe they were talking about a different language or something. Anyway, that's too bad. Maybe that would be good project for someone? maybe a system api that we can call somehow?

I know you can make a form application modal, but can you make it system modal like you can with a msgbox?

Hello, I have an interesting solution to a problem I've had for a looong time now. I have reports in an Access database that I have to run manually every day because the data source of the reports is a DSN connection to an iSeries server. I have to run these manually because no matter what...

Yes, storing the value of each checkbox in it's own field would be appropriate. The way I interpreted it was Progress wants to concatenate the value of multiple checkboxes and store that in a single field, which is usually not appropriate. Another way to explain what I said in post #2. Instead...

If you simply need to clean up the database window, you can write a function with all the queries as sql strings using docmd.runsql "" where you would insert the actual sql string of a query between the quotes. Repeat this command for each query you want to 'clean up'. Test the commands. Delete...

You'll definately have to write code to loop through each record in Scheduled Work Orders, call the function to grab the next workorder number, append it to the Workorders table, save the record, and continue to the next record in Scheduled Work Orders. Using this methdology, if the workorder...

Not sure, although I have seen it happen on .xls too, so it might be an Excel issue.

Storing multiple values in the same field is usually not advised as it usually identifies a problem with the design of your database. You would probably need to create a table with the values that each one of your checkboxes represents. Get rid of the checkboxes, and create a table that links...

That's a good point. Now that you mention it, I'm not sure how that would work in runtime. In that case, you might have to write the function to do the appending as well.

You would have to write a function that returns the last used number of that field +1. Then refer that field in your append query to the function. I.e If the name of your function is "GetNextWorkorderNumber()" then put that in the append query in the 'Field' section. There should be plenty of...

This is a curious problem indeed. Have you tried adding a break in the linking code and stepping through it? This can norrow down the problem to a single line of code in most cases. Also, if you have error trapping in your code, comment it out and see if Access throws any default errors. If all...

I have experienced this while importing an excel file into Access. The import fails if someone else (or myself) already has the excel file open. You may be experiencing a similar situation. If you are not writing data/changes back to the CSV file, then you might try writing a function to copy...

Could be a problem with the references, but I don't have much experience wth what's what as far as that goes. I think BobLarson would know.

Yes, that's it. I would like to thank everyone on this forum for giving your time away to help our members. Two years ago, I created a job for myself developing and managing the database we use in our call center. It was originally created in Access '97 and only recently did we upgrade the...

I feel honored. Never been compared to the king before!

I usually use Me.Requery (to refer to the form in which that code resides) or Forms!YourForm.Requery to refer to any other form. So, the workflow looks like this right?; frmopenlist -> frmclientprofile -> frmeditclient -> frmcloseout You could put the requery code in different places, it...

I've had that issue before... Not exactly with checkboxes, but I've had Access crash on a particular item like that before. I think the way I fixed it was; I created a new database on my desktop or wherever, then I selected File->Import and imported all the objects from the crashing database...

Can you set MSACCESS.EXE to run with compatibility settings? In the meantime, maybe the client can use virtual pc to run a compatible version of windows?

Is that a calculated field?