Search results

Allow me to shift the subject away from electric cars for a moment. I saw some graphs and data the other day which were pretty interesting. Of course I took them with a grain of salt because anybody can make a graph show whatever they want, but it was interesting nonetheless. It basically...

I'd like to see what you have in the rowsource property of the Transaction Type comboBox. I also noticed that you have a subform. You may want to look at the code on that subform, if there is any.

In most cases Simon_MT is correct in that you want each user to have their own LOCAL copy. In my case, we are in a terminal server environment, so whether the user's copy was on the ts or the fs, makes no difference. (they're practically on the same box). To answer your question about the batch...

Well, I see nothing out of the ordinary except for the first three subs which have nothing in them. Go ahead and replace all of that with this, and see if it helps. If you still get the same error, I would decompile the file and then recompile once more. We can help you do that if needed...

You're welcome. Well that's just confusing and now I'm taking shots in the dark, but would you be able to; post all the code on your form here. or Post the entire db file?

I used a scheme where I have my master design copy that nobody touches period. Then there is my primary .accde but nobody accesses it directly. Each user has a shortcut on their desktop which runs a batch file. The job of the batch file is to make a copy of the current primary .accde and paste...

Take a look at the checkbox's BeforeUpdate event. In that event, write code to test for checkbox.Value Something like this might do the trick Select Case checkbox.value Case True CurrentDB.Execute "Your SQL statement here;",dbFailOnError Case False...

Since you have a recordsource consisting of multiple linked tables, I would venture to guess that your recordset is not updateable. If you open visit_main manually, does it let you insert a new record?

Hmm. The first thing I would have tried is SendToBack on the subform, and BringToFront on the controls you want on top... but it sounds like you tried that already. Can you put the controls on the subform itself?

Maybe Access is interpreting this as dividing-by-zero ? try writing it like;

Being able to 'see' the tables and the data, and being able to 'change' said data are two completely different things. That depends entirely upon how your user schema was set up on the SQL Server itself. You might have read-only access. The fact that you didn't receive any errors doesn't say...

They're all using the same single .accde? as opposed to each user being given their own .accde? That could be part of the problem.

Hi 70Runner, Most likely, it is referring to a form event. Check the Form's property list and if you see any events with "[Event Procedure]" next to them, then check the respective vb code on the form. In your case, look for an event called AfterInsert. Play around with the debugging options of...

For indexes that are reliant on more than one field, I sometimes create a SuperKey. It is simply an Indexed (No Duplicates) field with a text datatype. when new records are created, my INSERT query inserts a calculated value into that field. i.e. given a table with the following fields: [ID]...

As a general rule, if you have anywhere close to 255 fields in a single table, you're database needs to be normalized. When it comes to storing data in a database format, you only store the raw values and when it comes to displaying a calculated value you can do that in a query on the fly...

It sounds like what you basically need is a user-entered value (in this case Date) to be passed along from one form to another. If that's correct then the easiest way I can think of is by using the OpenArgs form property. i.e. Form1 -> User enters Date -> User clicks Proceed Proceed button...

nope. I just enjoy a challenge. I could program and build systems 'till the day I die; the more complex the better.

@jzwp22 Nice post! It's been a while since I've posted but this got my creativity flowing. Your model is well on it's way to becoming a fully-fledged Academia Management System, capable of assigning classes to students for their formal schedules. All it needs now are a set of tables outlining...

Oh okay... for some reason the original SELECT query was not updateable so I felt the need to use a separate UPDATE query. It's updateable now so I tried the .Edit method again but it is still painfully slow. At this point, I should mention that the backend is in SQl Server 2008, but I NEVER...

Thanks for your suggestion, it definitely got me back in step. Here's what I have so far: strSQLSelect = "SELECT TOP " & intRequest & "tblAvailableOrders.OrderNumber, tblAvailableOrders.TimeZoneDesc, tblAvailableOrders.intCallCenterID FROM tblAvailableOrders WHERE...