Recent content by Glimmerman

Hey everyone, it worked perfectly, thanks!

Hi im trying to make pass through query that triggers a database restore on a SQL server based on a few parameters entered in a form. As soon as i run the command button the output just put all lines as one line without line breaks, can anyone help me on whats going wrong here? Here is my...

Hi there, Im in need of a SQL select query to get values from a specific field and table in all databases on the server these databases are generated with an random name an various schemas by an application, but the specific field i want the value for is allways in the same table and has the...

Ok it was not really doing it for me but i did manage to setup a table search form that would plow through the whole table by using this in as field criteria: Like nz([Forms]![frmSearchForValue]![txtSearchfield] & "*") I used this on all fields as criteria and or So im going to use this to...

sorry for the late reply, i had some other things to attend to, i will look closely at what you have created and let you know if its applicaple :) thanks for the effort so far anyway, its really appreciated.

You see what got me puzzeled as well? :) Im open to any kind of solution, but my knowledge of VBA is still very limited unfortunatly.

Unfortunatly its not working for me, im not getting any results back. Ive included the criteria query with source table and form from my database, perhaps you or someone else can figure out what im doing wrong then. Basicly what i want for results is that after i specify the persiod, i want to...

thnx ill have a look! :)

Hello, I have an issue with a multiple criteria query in Access 2007. I have a database where we do reviews on tickets logged in a helpdesk tool. Now im building a search form where i can set certain criteria on multiple fields so i can refine my search. I want to do this by selecting a start...