Search results

HI All, I have a crosstab query that runs in about 9 seconds.. pretty good i would think. My issue though is everytime I try to turn it into a form, access stops responding. I tried specifying an ID to narrow down the query and now I cant even save the query... Does anyone have any tips on this?

Does anyone know why access 2010 would not be able to handle this where statement? WHERE ((([dbo_Calendar].[endYear])=IIf(Month(Now())>=7,((Year(Now())+1)),((Year(Now())))))) I get a compile error . in query expression, but 2007 handles it just fine!

Is there a way, in access 2007 for the tables to automatically open in design view instead of datasheet view? I turned off "Enable Design Changes for tables in datasheet view" thinking that that would fix the problem, but now they open up in datasheet view with just the ID field and i still...

Hi all, Im scheduled Tuesday for ACL surgery on my right knee. Was wondering if anyone had any tips for me and what i should be expecting as far as getting back into regular activities.. I googled it and found some responses, but interested to hear from you guys too. Stupid me I looked up...

Im pretty sure im doing this wrong, but I cant think of any other way to do it. My issue is I have a link table where the user ID , date and approval are entered in to the table to give me a request ID. I would then use the requestID and add into another table along with many other things...

Hi all, I am writing php script to return the results from a query that I wrote in sql, but am getting the "too few parameters. expected 1" error. The query runs fine in access, but in when I insert it into the php script to return the results, I get the error. This is the code. SELECT...

Has anyone ever created an internet usage agreement website. I'm looking for something like the hospitals or hotels have here in the states where the first time you login to the internet you need to agree to the terms and conditions... has anyone seen this before or knows how its done? Thanks

Don't get me wrong I love win 7, but I'm running into so freaky problems with it. I have a query that runs fine in XP and 2007, but with win7 and 2007 i get "Invalid operation".... Has anyone else ran into issues like this?

Has anyone ran into any issues with access and windows 7? I have a db that runs perfectly fine in XP and 2007, but when I try to run a report on my win7 and 2007 it freezes every time!!! Has anyone run into this? Oh and its 64bit Win7...

So im not sure if anyone out there has dealt with this, but Time Warner is implementing a bandwidth cap in my area. Linky Does anyone here have a plan such as this? I game and stream movies through netflix all the time, and now its looking like im gonna get it hard if i try to do this...

I was wondering if anyone has a way of addressing the fact that users often have different printers that, on occasion will cause the reports to print out formatted incorrectly. I have had a few tell me that a bitmap placed on the report, also a checkbox has not shown up for them when they try...

[Resolved] open recordset not working like i thought Hi all, Does openrecordset only work for queries that are already created? I thought that this would work Set rs = Db.OpenRecordset("select * from tbl_benchskill where ((studentYearID= Forms!frm_aisreportCard!Text47))", dbOpenDynaset)but it...

[Resolved] Reselect items in listbox based on records Hi all, So I have a set of records that I want to let people edit when they realize they have made a mistake. Currently they select from multiple listboxes and that populates records based on their user ID What I would like is if they...

So my question is has anyone had any experience or seen code anywhere that will give Admin Rights to power users for software install.... I want to create a vb program that will allow power users (me) to install any software as an admin on other computer without having to go in and make my...

Anyone else have problems with 2007 and their buttons? It seems that if i change one thing, i lose all actions for my buttons. Anyone have some ideas on what could be causing this?

Wanted to say thank you to everyone who has helped me over the past year. on Monday i start a new job and im not sure how much access development that will entail or if i will be able to contribute (or hinder) the forum very much. so THANK YOU!

Run afterupdate on subform by running afterupdate on mainform? Hi all, Is it possible to fire the afterupdate event of a control on a subform by firing it from an afterupdate of a textbox control in the mainform? i have a combobox on my subform that runs an update based on values in the...

Hi all, Im trying to catch this error to tell my users that they must fill in 2 combo boxes before they can proceed to the subform, but i dont know where to put it to catch it. thought it would go in the before_update of the form, but i was still seeing the generic "The microsoft Jet database...

Hi All, Can someone point me in a direction to get some good information on how and when to use recordsets? Ive gotten by without having to use them for the most part up until now.. but the inevitable has happened and i figure i might as well learn to use them for the most part i know When to...

Hi all, thinking about starting to take some vitamins to maybe see if i can squeeze out some more energy. anyone know if something like centrum or something like that is good for this? also does anyone take fish oil? ive heard its supposed to be good for u, but im not too sure why