Protecting a split database

I’m working on preliminary ideas to revamp a split Access database. The first version encountered two serious issues:

  1. On occasion, network outages or even hiccups would cause the backend to become corrupted.
  2. New task creation sometimes assigns duplicate UIDs (we use custom UIDs that are a concatenation of task category, date, then numeric sequence) because the UIDs are formed by the frontend VBA. No validation for different frontends simultaneously creating tasks.

My supervisor is very set on implementing passthrough instead of linked tables to alleviate both issues, but I haven’t found any good information on whether that is viable for Access-to-Access. Thoughts or suggestions?

submitted by /u/racerxff
[link] [comments]

Posted on

How To Convert Access Database From Accdb To Mdb File Format?

Summary: This tutorial mainly focuses on how to convert Access database accdb to mdb file format. However, converting MS Access database between versions require your attention and additional planning of your database. So, here is complete tutorial which demonstrate the…

Posted on

New to Access, need a little help

Hey guys,

at work, we’re trying to build a database to get an output of all kinds of data from different excel tables (items in stock, sales per week, price, etc) into one table by using the ItemID as primary key for all the tables and as a user input for the queries.

I’m completely new to Access, I do have some experience in Excel and databases in general though. I’ve linked the tables to each other and sucessfully inplemented different queries. However, I have a few questions that I can’t really find a good answer to online:

  1. How can I ask for multiple values when asking for user input? (For example: I want the user to be able to put in multiple itemIDs so they can compare sales/week in a table that has multiple rows)
  2. Is there any way I can automatically link new tables to all the other ones? There’s a new table including data about sales etc. coming out every week. Does that mean I have to manually link it to the other tables in my database and also edit my queries every week?

Thank you guys in advance!
Cheers!

submitted by /u/Brianizer
[link] [comments]

Posted on

Update queries corrupt after latest windows/office update?

Hi all.

Just experienced an issue with our access database. Basically it seems that all ‘update’ queries are showing an error as them being corrupt.

I have done some tests and it only seems to be happening when the database is being run through the latest version off office (which was just updated in the latest windows update).

I think it is V 1910?

Is anyone else experiencing similar issues, or know of a fix other than doing a rollback/system restore?

I hope I have explained myself well enough and this all makes sense.

Many thanks in advance.

submitted by /u/DanJesusWhite
[link] [comments]

Posted on

How can I start report pg. # based on another report’s pg. count?

Hello,

I am trying to start the page number of a report based on the page count of a separate report in Access 2007. I’ve added a text box in report design in my page header section, and I input =Reports!OtherReportName.Pages+1 and it auto-corrects it to =[Reports]![OtherReportName].[Pages]+1, but gives an error when I try to view the report. What am I doing wrong? How do I reference this correctly in Access 2007? All help greatly appreciated!

submitted by /u/Idunnoitsforwork
[link] [comments]

Posted on

I have a drop down list on a form that I cannot get conditional formatting to work on (I want to color the field if text is not equal to certain phrases)

Hello!
I am having a heck of a time. So I have two existing conditional formatting rules for this drop-down field. One makes a field turn yellow if the selected option is either “-” or “” (blank). The second rule turns the background green if the expression is “Complete.” The drop-down list has like 100 more selectable options, and I want a rule that will turn the field red if any are selected other than “-” , “” , or “Complete” but I can’t seem to get it to work by using <>. How can I write this final rule? Thanks!

submitted by /u/MrManager689
[link] [comments]

Get the best Microsoft Access conultant

Get the best Microsoft Access programmer

Posted on

Noob question: search and open record to add data

Hi everybody,

I hope this is the right place to ask this. I am having a bit of trouble with a database I’m trying to create.

A bit of info about the database:
It’s a database for containers. When containers arrive, the check-in is handled by person A. person A creates a new record with a form. The container gets a unique number and some data is added, like what is in it, the time of arrival and what it needs to do here.

When the check-up of the container is done, I need to be able to add the time of departure to the record.

For this, I would like to have a second form where I can let the people search the record on the ID, it opens that record in the same form with the container number, and a field to add the time of departure.

Anybody know how I can do this?

I am pretty new to Access and have learned a lot, but I am really stuck on this problem.

submitted by /u/pika-pika-chu
[link] [comments]

Get the best Microsoft Access conultant

Get the best Microsoft Access programmer

Posted on

How to make For Each loop to cycle through predefined set of controls

So here’s a little problem I’m having in VBA: I have 7 unbound labels on my form to represent dates. I also have a Combo Box with numbers 1-4 to represent a specific week. What I am doing is updating all the date labels to relative to a specific day, and currently updating it manually is a little inefficient:

If Me.weekCombo.Value = 1 Then
Me.d1.Caption = FormatDateTime(DateAdd("d", 1, Me.startDateList.ItemData(0)), vbLongDate)

Me.d2.Caption = FormatDateTime(DateAdd("d", 2, Me.startDateList.ItemData(0)), vbLongDate)

Me.d3.Caption = FormatDateTime(DateAdd("d", 3, Me.startDateList.ItemData(0)), vbLongDate)

Me.d4.Caption = FormatDateTime(DateAdd("d", 4, Me.startDateList.ItemData(0)), vbLongDate)

Me.d5.Caption = FormatDateTime(DateAdd("d", 5, Me.startDateList.ItemData(0)), vbLongDate)

Me.d6.Caption = FormatDateTime(DateAdd("d", 6, Me.startDateList.ItemData(0)), vbLongDate)

Me.d7.Caption = FormatDateTime(DateAdd("d", 7, Me.startDateList.ItemData(0)), vbLongDate)

ElseIf Me.weekCombo.Value = 2 Then

...

So what I want to try and do is make a set of all the date labels (d1-d7) at the top of the function and have a simple ‘for each’ loop that goes through each label in order and updates it accordingly. Pseudo code is below:

if combo = 1 then:

for i =1; i<8; i++ :

d1.caption = DateAdd("d", i, date)

else if ....

Now the only problems I have are A) I don’t know how to make the set of labels, and B) I don’t know how to make the for loop. Any help is appreciated!

submitted by /u/hquaker1
[link] [comments]

Posted on

How to make For Each loop to cycle through predefined set of controls

So here’s a little problem I’m having in VBA: I have 7 unbound labels on my form to represent dates. I also have a Combo Box with numbers 1-4 to represent a specific week. What I am doing is updating all the date labels to relative to a specific day, and currently updating it manually is a little inefficient:

If Me.weekCombo.Value = 1 Then
Me.d1.Caption = FormatDateTime(DateAdd("d", 1, Me.startDateList.ItemData(0)), vbLongDate)

Me.d2.Caption = FormatDateTime(DateAdd("d", 2, Me.startDateList.ItemData(0)), vbLongDate)

Me.d3.Caption = FormatDateTime(DateAdd("d", 3, Me.startDateList.ItemData(0)), vbLongDate)

Me.d4.Caption = FormatDateTime(DateAdd("d", 4, Me.startDateList.ItemData(0)), vbLongDate)

Me.d5.Caption = FormatDateTime(DateAdd("d", 5, Me.startDateList.ItemData(0)), vbLongDate)

Me.d6.Caption = FormatDateTime(DateAdd("d", 6, Me.startDateList.ItemData(0)), vbLongDate)

Me.d7.Caption = FormatDateTime(DateAdd("d", 7, Me.startDateList.ItemData(0)), vbLongDate)

ElseIf Me.weekCombo.Value = 2 Then

...

So what I want to try and do is make a set of all the date labels (d1-d7) at the top of the function and have a simple ‘for each’ loop that goes through each label in order and updates it accordingly. Pseudo code is below:

if combo = 1 then:

for i =1; i<8; i++ :

d1.caption = DateAdd("d", i, date)

else if ....

Now the only problems I have are A) I don’t know how to make the set of labels, and B) I don’t know how to make the for loop. Any help is appreciated!

submitted by /u/hquaker1
[link] [comments]

Posted on