Search results

I have an application that works fine on WinXP but when it is used on Win2k the screen that uses the Format() function won't load. Anyone ever had this problem?

Can't seem to figure this one out. If (FormatDateTime(Now(), vbLongTime) > #9:00:00 AM#) And (FormatDateTime(Now(), vbLongTime) > #9:00:00 AM#) Then SQL = "expression" else SQL = "diffexpression" end if Now when the form loads up it is always going to the esle statement wven when I set...

Hey all. I'm a having a sever brain fart in VB due to programming in C++ for the past month. Just have a quick question. Is there a switch you can use with the MsgBox function that will give you multiple lines in the message box. Thanx in advance.

Hey everyone. I got bored one day at work here so I made up a little installer for your Access applications. It's nothing fancy but it does the job. The app was done is C++ so noone should have any trouble running it. Please post feedback and suggestions. Thanks Access Installer

Anyone know of the control for opening files. I want to allow the user to select a file and click open and then the path of the file goes into a text box. Anyone help me out. Thanks

Hey all, Just wondering if it was possible to link to a specific record in a database by using a link to the database? ie. C:\db\db.mdb -record Or something like that. Anyone know? Thanx

Hey all, Got a little problem. I have a combo box which has a list of values from a table. When a user selects a value it gets added to a text box. Now the problem I am having is when the user first opens the form and selects a value it doesn't get added to the text box. But if they select...

Anyone have the link for the ActiveX controls demo database from Microsoft. I can't find it anywhere. Thanks.

Anyone tell me how to get data into a Tree View using the ActiveX control. I can't figure the thing out.

Hey guys. What are some cool features you have added to some of your programs. I have completed a program and want to add some interesting stuff to it but don't know what to add. It's a Planning System by the way. Anyone?

Because this was brought up in my previous post here is the solution to disable the user from using the shift key to access the database window during startup. 1. Create a new module and past this code inside it: '---------------------------------------------------------------------' ' Module...

I have a user maintenance screen that displays all their information and allows them to change their passwords. How can I get it so they stay on there record only and not go into other records. What's happening now is that when they tab through all the fields it goes to the next record. How...

I might be missing something and this may be really stupid of me but how come I can't edit a query. I have another query I use which is aloowing me to add records and edit them but I created another one and it won't let me edit it in my form. The AllowEdits and Allow Additions is true in the...

Hey all, I'm fixing a database that someone has done so what I did was created a blnk database and imported everything out of it. Well now i get an error and can't figure out why. When I open the original I can't do nothing to it. Hitting F11 doesn't show the database window and the previous...

Hello all, I get this error in my database all of a sudden. Db worked great before the weekend now when I try to link tables I get this error. Anyone know why and how to get rid of it. cheers,

Hello, I have a form with various fields. I have it laid out like a chart. Also I want the field to be invisible if there is no value located in the query with that number. Here is my code to help you out. sqlPart = "SELECT * FROM tblParts WHERE Area='" & PArea & "' AND [Page]='" & PPage &...

Anyone know a way to set the now function a week in advance. When the user uses a form I have a text box setting the current date. But I want the date to be the monday of the next week.

Hello, I have to database and I am exporting from one and putting it into another. Now I have made the tables equal so importing should word. Now my problem is taht when I export from the db into a txt file I use , as the delimiter. When the data gets exported and I open the txt file I...