Search results

I have a VBA script that opens a intra net web page and downloads data from it. The data is stored locally in Access tables. After the tables are filled, the script ftp's the database to the web. This script is set to run every night at midnight and has worked well for months now. I had to...

I've been coding some ASP pages and I am starting to think a tag cloud would work great. Does anyone have any idea how these work? Are tags and clouds even relational?

Access 2007 developers extensions and Access 2007 runtime are here: Blog Post Download ADE Download Runtime

I've heard this before but this time it may hold some truth.. Read more I am still using ODE97, and I think I am going "step up" to ADE2007. It only took me 10 years, lol Hope I am not dissappointed.

I created a database for a school. In order to reduce database bloat I backup the backend db's every term and wipe all the tables clean. Now the situation has arose that I need to give the users access to data over multiple years. I could do this a couple of ways, and I am looking for your...

I am pretty good in VBA, but normalizing databases is not my strong suit. I am missing a major piece of insight. Here's the situation. I am building a shipping db and after I create the relationships between my tables I fail to see how to add new records. I am assuming I would have to build...

Can't find this anywhere, so I am posting this. I've built a DB with (Access 2003). I want it to look more like a program and less like access. For Example, my app allows you to export and import all database tables, with a file extension *.blk I setup up a Menu Bar commands for Save and Open...

I am trying to write a query showing me all tv shows on right now. The design of the tables are unchangeable because they are given to me. The 2 important fields in the Schedule table are: time (which is a date/time value, for when the program starts ex: 2/3/05 8:30AM) durations (a number...

I am very comfortable with MS Access and VBA. It is definitely my database language of choice. Anyway, I want to send information from my tables into a web server so users can hit the website and search for records. From reading the forums, I can see the Data Access Pages is not the way to go...

I am about to give this database to a client. It basically manages deliveries. Everything on my form is functional. The problem is Access seems to freeze indiscriminatly. I have no idea why. I don't believe Access is processing code when it freezes because control-break does not even work. I am...

I am using A2k with a continuous form, and I want to use conditional formating to alternate colors by job #... so JobNum: 111222 might have 3 records of the same color while the next job 111333 might be one record and should have a differnet color. Basically Job 1 would be blue then job 2 would...

I am now using Access 2000+ to create new applications. I find myself limited in what conditional formatting can do. For example, I want to use a conditional format to change the text color to a certain shade of blue (12554099). Conditional formatting only gives me the choices of basic colors...

I have created a floating toolbox much like the floating toolbox you see when you design a form. I want my buttons to stay depressed the same way they do in a real toolbox. It must be possible... I just have no idea how.. any info is greatly appreciated

Can I create an MDE file from an MDB through Code? I searched the forums with no success

Assuming this: Dim bln1Up, bln2Up, bln3Up as Boolean Lets say I want to change one of those boolean values based on the middle character... for example Private Sub Whatever() Dim AddKey as Integer If ("bg" & AddKey & "Up") = True Then Call Correct ("bg" &...

I never really learned the differences between Public/Private, Function/Subs... instead I found what works and went with it. I have 12-15 modules in my DB, basically grouped by catagory. For example modPrintJobs, might have 12 public functions all related to printing. I might have 10 Public...

I fear I have outgrown MSAccess as a backend... I have 70+ users now and things are running pretty darn slow. I have so much more data now and so many more tables etc.. My main reason for the move is speed. From what I understand, If I query 5 records from a table across the network. Access...

I have a networked FE/BE database in Acc97. The FE is on about 30 machines in the building. On 40% of the machines I keep errors like... Error Undefined function Left([StuName], 4) or on Mid([Whatever], 1, 3). Seems like all the string functions dont work. I can't seem to figure out why this...

I have developed a database application for a school. It's a network application back-end/front-end, with up to 30 users at a time. I am trying to improve my database speeds, which seems to get slower with more database objects added. I now fear I fell into common pitfalls when I created my...

i have some code on click of a list box Private Sub ReqCourses_Click() MsgBox Me.ReqCourses.Column(0) End Sub Everytime I click an item on this list box nothing happens... no error no msgbox. It's referenced properly.. name of listbox matches name in code window. I also have a command...