Search results

Hi! Assuming the numbers are in records in a table, try Sub Con_Nums() Dim Dbs As Database Dim Rst As dao.Recordset Dim Con_Count, Max_Con_Count As Integer Set Dbs = CurrentDb Set Rst = Dbs.OpenRecordset("Consecutive Numbers") Rst.MoveFirst Do While Not Rst.EOF 'Debug.Print "ID:" & Rst!ID &...

Probably.... if that problem continues though might be worth starting a new thread. Anyhoo no worries, have a good afternoon :)

Apologies, pre-morning coffe thread answering never good :) Try .value instead

XP is fine to share between itself, but I think Vista treats networking slightly differently (and badly). Things to consider: Can all the machines ping each other? Are all the machines part of the same workgroup/domain? If the machines can see each other, are folder permissions set properly...

Yeah, or just use the machine you used to develop the DB in the first place - either way, full Access is the only option here.

You might be better off using a subform for that. As I say, you can't just create tabs in form view, they'd need to exist already and you'd have to programatically unhide them as you go along.

Then you might have to do something like having a yes/no field in the underlying table to say "being edited" and set that to True when the record gets the focus.

Ok - in the place of "docmd.openform "Project_details",,acnewrec" in your button, putdocmd.openform "Project Details" docmd.gotorecord acdataform,"Project Details", acnewrec and take the gotorecord out of Project_detail's open form event.

OK - I've just had a look at your database and you've got the design a bit wrong. You need to think about tables almost as subjects - examples would be stock, sales etc. You're also treating tables like spreadsheets - you don't need to insert any blank lines in between subjects in each of your...

Have a read of this, see if it helps: http://office.microsoft.com/en-us/access-help/about-sharing-an-access-database-on-a-network-mdb-HP005240860.aspx

Don't cry, you'll short out your keyboard... is the above producing an error?

You could just use an update query for this, nice and easy.

You'll have to use the full version of Access to create linked tables to the network DB, then it should work OK in the runtime. If you're unsure of the location of the BE, you can set the Connect property of a linked table using VBA, but that's another story....

Welcome to the forum! Try =sum(iif([Id_Tip]=6,nz([Supr],0),0))

Sounds like you've got your option there - your ISP is able to host an Access database, they'll have their own ways and rules around connecting to it. MySQL is a different database platform but you can interface it with Access. Have a read up about it on their website: www.mysql.com

It's a bit annoying to start with, but now I've been using 07 for a while I find 03 to be clunky... I did see somewhere that someone had made a form that functioned like the 03 DB window and hid the navigation pane, christ only knows where though...

Hi! - Probably the best thing to do is not to worry about the Sat-Sat weeks when users are entering data, just worry about that when you're reporting. Just have the user select their name, the date, and enter a downtime reason. Then when you're reporting, group by the week you want?

Morning! Couple of things I noticed: Doesn't look like you're selecting a record in your recordset The code you're using to populate your text boxes is commented out A couple of the lines are the wrong way round:'rs!FAX = Me!txtFax.Text 'rs!Email = Me!txtEmail.TextShould be...

Hi - I would prbably do this with a Search button and just have the follwing code therein:if combo1.value="M" or combo2.value="M" or combo3.value="M" or combo4.value="M" then Msgbox "M found" Else Msgbox "M Not Found" Endif

Welcome to the forum! The if true part of your statement should be, I think, either "*" or "Like '*'"